p.s. if your trying to do an update query, just change your query to "update database" not "insert database"
-----Original Message----- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 2:19 PM To: CF-Talk Subject: RE: <cfquery> not working after migrating from MySQL to MS SQL oops forgot this. insert into database ( env_var, destination ) values ( <cfqueryparam value="#ListGetAt(Line,1,'|')#" cfsqltype="CF_SQL_LONGVARCHAR">, <cfqueryparam value="#ListGetAt(Line,2,'|')#" cfsqltype="CF_SQL_LONGVARCHAR"> ) that should work. -----Original Message----- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 2:08 PM To: CF-Talk Subject: re: <cfquery> not working after migrating from MySQL to MS SQL What's wrong with this. It's giving me a syntax error. SYntax error near the keyword 'SET'. <cfquery name="update_alias" DATASOURCE="database"> INSERT database SET env_var=<cfqueryparam value="#ListGetAt(Line,1,'|')#" cfsqltype="CF_SQL_LONGVARCHAR">, destination=<cfqueryparam value="#ListGetAt(Line,2,'|')#" cfsqltype="CF_SQL_LONGVARCHAR"> </cfquery> This worked fine under mySQL ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
