The cfparam is there because cfqueryparam can't handle the value
attribute if the variable doesn't exist (read my first post entirely)! I
want to insert null if the string is empty.
The point is you should always use cfqueryparam in your queries (as
discussed in about a hundred other threads on this list).
Pascal
> -----Original Message-----
> From: Robert Munn [mailto:[EMAIL PROTECTED]
> Sent: 29 July 2004 10:22
> To: CF-Talk
> Subject: Re: HELP - having trouble with a insert query.
>
> >Or even better: USE CFQUERYPARAM !!!!!!!!!!!!!!!!!!!!
>
> cfparam ...
>
> ><cfparam name="form.size1qty" value="">
>
> But make sure to NULL your default values ...
>
> <cfparam name="form.size1qty" value="NULL">
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
