[cfaussie] Re: MySQL and CF
Thanks guys, Yeah I worked that out a few days ago. This question didn't go up for DAYSmust have been a google thang. Thanks anyway. Jeremy --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: MySQL and CF
Where are you seeing the question mark? In the debug output ? -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of cfgroupie Sent: Thursday, 12 October 2006 9:44 AM To: cfaussie Subject: [cfaussie] MySQL and CF Hi guys, I posted this yesterday but I'm unsure how come it didn't arrive on the list. Nevertheless I'll ask again. In my CFQUERY I am using the CFQUERYPARAM tag cfqueryparam cfsqltype=cf_sql_integer value=#CheckCandidate.CandidateID# / Now most of the stuff I work on is in MSSQL. But I've recently takin up a MySQL contract in which I will be required to use a MySQL database. When I use the above code with cfqueryparam in my SQL statement I get ? marks where the value should be. Is CFQUERYPARAM only for MSSQL or am I missing something with MySQL? Jeremy --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: MySQL and CF
That's normal. The question mark indicated the value will get plugged in somewhere down the line. If you look within a few lines of the SQL statement, you'll see the actual values that get plugged in to where the ?s are. cfgroupie wrote: Hi guys, I posted this yesterday but I'm unsure how come it didn't arrive on the list. Nevertheless I'll ask again. In my CFQUERY I am using the CFQUERYPARAM tag cfqueryparam cfsqltype=cf_sql_integer value=#CheckCandidate.CandidateID# / Now most of the stuff I work on is in MSSQL. But I've recently takin up a MySQL contract in which I will be required to use a MySQL database. When I use the above code with cfqueryparam in my SQL statement I get ? marks where the value should be. Is CFQUERYPARAM only for MSSQL or am I missing something with MySQL? Jeremy -- Haikal Saadh Applications Programmer ICT Resources, TALSS QUT Kelvin Grove --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---