php - sql query don't pick the value -


i have simple sql insert query:

insert db_name (col1, col2, col3, ...)  values ('value1', (select name another_table id = :php_value), value3 .....)

but col2 value null because select don't pick nothing (name exist) possible protect empty records? or need change script , keep select before insert (outside insert)? that's happen not regularly ~1/3000 records

i think problem condition id = :php_value query doesn't return data. can avoid insert row table empty name way:

insert db_name (col1, col2, col3, ...)  select 'value1', name, 'value3',...  another_table  id = :php_value

-

Comments

Post a Comment

Popular posts from this blog

php - Wordpress: Link a post to posts of another category manually -

i have 'events' post type. have category called 'speakers' , has posts speakers. when creating event need select speakers each event through backend. need give interface admin select speakers event. i recommend using advancedcustomfields-plugin . can build "relationship" between post type 'events' , 'speakers'. way can choose 'speakers' on every 'event'. the plugin documented. see how works: http://www.advancedcustomfields.com/resources/relationship/
Read more

delphi xe7 upload/download dropbox file using the rest client and show progress -

using xe7 rest client able authenticate , kind of information file list, account info, etc. how can upload , download files progress indication? uploading useful if there examples small file using /files_put (max file size 150mb) , bigger 1 using /chunked_upload dropbox api thank you! you should provide code have problem with. don't expect job you. to give @ least hint: you send put request using idhttp according documentation have mentioned. don't forget add header "authorization" login information rest client. idhttp.put('https://api-...', ffilestream, fresponsestream); this block main thread (ui) if want upload/download , show progress, have use separate thread - first create tthread, in "work" procedure run upload/download. now have handle progress. can in onwork event of idhttp component. pass status thread main thread. don't forget synchronize call correctly - can use idnotify this. google these basic stuff. ret...
Read more

java - Get more than One value and display it -

i checking 'n' number of servers every minute, if servers down mail triggered user server name down. issue facing if more 1 server down getting 1 server name down. how name of servers down. obj = dataaccess.getservers(); //getting status , links of servers mailserver sender = new mailserver(from,password); list<string> downserver = new arraylist(); (map<string, string> objs : obj) { //iterating each server serverstatus = objs.get("status"); if (serverstatus.equals("down")) { servername = objs.get("name"); statusserver=objs.get("status"); } downserver.add(servername); if(!(servername.equals(null))){ sender.sendmail("server status",downserver.get(i),from,to) } without checking reasonability of code or trying improve anything, code should little more following (at least) come clo...
Read more