On 9/25/05, Steven Lembark <[EMAIL PROTECTED]> wrote: > > This coding may not be so difficult, but not easy for me. > > The issue will be converting: > > insert into foo ( field, fields ) values ( ... ); > > into > > insert into foo ( field, fields ) values ( ?, ?, ? )
...especially if one of the values happens to be a SELECT statement, or a function call, or something equally fun? INSERT INTO WhatNot VALUES (1, "abc", (SELECT dismal FROM failure WHERE antidote = 'mercury'), MDY(MONTH(TODAY), 1, YEAR(TODAY) + 2)); This may or may not be standard SQL; it is practical SQL for at least some DBMS. -- Jonathan Leffler <[EMAIL PROTECTED]> #include <disclaimer.h> Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org "I don't suffer from insanity - I enjoy every minute of it."
