Skip navigation links

MySQL Forums :: Newbie :: Dynamic Queries: passing values as column list, and inser values


Advanced Search

Dynamic Queries: passing values as column list, and inser values
Posted by: John Birdsell ()
Date: January 20, 2013 07:46AM

Hi,

i am using mysql 5 as a backend to a ColdFusion 10 app.

What I am trying to do is pass variables into an insert statement.

like so:

INSTERT INTO #tableName#(#columnNames#)
VALUES(#colValues#)


In the above code #tablName# is coldfusion syntax for a variable.

When I dump the variables the values are correct
#colName# holds a list of column names like this (col1,col2,Col3)
#colValues# hold a list of variables that will be used by a query looping over this one supplying the actual values. Like this(#col1#,'#col2#', #col3#)



What is happening is that I am getting a mysql error that is a generic parsing error. it's indicating that the error is in last line of the query,

On the Coldfusion side,all variable names are correct and the correct case, They are scoped correctly where #col1# represents a numeric value and '#col2#' represents a text value.

So if anyone has any ideas, they would be greatly appreciated.

thanks
jbird



In researching this I have not found anything relating to passing variables like this nor building a dynamic query like this.

Options: ReplyQuote


Subject Written By Posted
Dynamic Queries: passing values as column list, and inser values John Birdsell 01/20/2013 07:46AM
Re: Dynamic Queries: passing values as column list, and inser values Peter Brawley 01/20/2013 11:52AM
Re: Dynamic Queries: passing values as column list, and inser values Rick James 01/20/2013 12:19PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.