RE: bind params and default values

2003-10-27 Thread Dathan Vance Pattishall
bject: Re: bind params and default values -->INSERT INTO my_table (A, B) VALUES ( COALESCE(?, A), COALESCE(?, B) ) --> -->I think this should work, but am now wondering how much time this will -->actually save me. I say this because in this situation, even though the -->query -->i

RE: bind params and default values

2003-10-27 Thread Dathan Vance Pattishall
-->-Original Message- -->From: sean peters [mailto:[EMAIL PROTECTED] -->Sent: Monday, October 27, 2003 10:17 AM -->To: [EMAIL PROTECTED] -->Subject: bind params and default values --> -->Hi all, i've been having an issue with binding params. If i have created -

bind params and default values

2003-10-27 Thread sean peters
Hi all, i've been having an issue with binding params. If i have created an INSERT query with a param binding to a particular column, call it column "A", is there any way that i can use that (prepared) query to get the db defined default value into column A? Im at a loss! thanks much, sean pe