Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by phlat
-
Please help with GetFileTime
Thank you! This is what I've been trying to do. I am using VC++ BTW- phlat
- Post #3
- Forum: Microsoft: Visual C++
-
Please help with GetFileTime
I'm not really a C programmer but I know enough to be dangerous. How can I assign the file created date via GetFileTime to szOptionalField1? Thanks! struct _FILETIME ft;SYSTEMTIME stUTC, stLocal; GetFileTime(szCsvFile,&ft,NULL,NULL); FileTimeToSystemTime(&ft, &stUTC)...- phlat
- Thread
- Replies: 3
- Forum: Microsoft: Visual C++
-
Need to use UPDATE instead of INSERT INTO
I was able to solve my problem using a single INSERT SELECT. My problem was that I needed to cross join the other table and provide the correct WHERE conditions. I found a good tutorial that helped me with MySQL. http://www.keithjbrown.co.uk/vworks/mysql/mysql_p5.shtml This is my working... -
Need to use UPDATE instead of INSERT INTO
I think I understand. Would you be so kind as to provide a possible example? I'm pretty new to this MySQL stuff. Thanks again, Chad -
Need to use UPDATE instead of INSERT INTO
Unfortunately REPLACE INTO overwrites the other two existing fields. To clearify there are four fields in the table. Two are getting populated by a previous INSERT INTO. So I need to UPDATE the remaining two somehow. This is the dilemma. Thanks. -
Need to use UPDATE instead of INSERT INTO
I need to UPDATE exisiting rows and populate the fields using only the resources in this INSERT statement. INSERT INTO cms.project_event (projectPhaseID,sortOrder) SELECT cms.projectTemplate_eventTemplate.projectTemplatePhaseID, cms.projectTemplate_eventTemplate.sortOrder FROM...
