> > <CFQUERY name="addPO" datasource="purchaseorders"> INSERT INTO
> > itemsordered
> > (item)
> > VALUES
> > ('<cfqueryparam value=#Trim(session.item[i][2])#
> > cfsqltype="CF_SQL_CHAR">') </cfquery>
> >
> > It still gives a incorrect syntax error.
> >
> > How do I correctly incorporate that into the above insert?
>
> Get rid of the apostrophies, you don't need them - see our examples

Shouldn't you also be using " " around the value?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to