Hello! Alexander Thurgood: > So the question is not whether you can use prepared statements, but > whether you can use parameterized queries in prepared statements ?
Well, yeah, actually :-) Alexander Thurgood: > I guess I would start with whether the simple parameterized SQL > statement actually runs correctly from within the LO Query SQL editor ? It doesn't seem to work. I tried SELECT "col1" FROM "tbl1" WHERE "col2" = :x and just got a bunch of errors (listed below). I did some googling already but didn't find anything yet. I have some actual work that has to be done so I'm going to have to return to this a little later. Thanks for the tip! 1. The data content could not be loaded. 2. SQL Status: 42000 Error code: -2147217900 Incorrect syntax near ':'. 3. SQL Status: 42000 Error code: -2147217900 Statement(s) could not be prepared. -- View this message in context: http://nabble.documentfoundation.org/SQLException-when-using-ADO-driver-and-prepared-statements-tp4070605p4070700.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
