Bruce,
> The Venue_City_ID is the comma separated list. The field in the
> DB is a text field (SQL Server 7). When I view the output, I get
> something like '3,4,5'. I would think that this would be OK since
> everything is inside of single quotes. However, I am receiving errors.
>
> ODBC Error Code = 37000 (Syntax error or access violation)
>
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect
> syntax near '3,4,5'.
>
Is Venue_City_ID actually a string in your database?
How about normalising your database a bit more and having a coupon_city
table that has the fields CouponID and CityID and then inserting a record
for each cities per coupon eg.
<psuedo code>
insert coupon details
Get new couponid
Loop citylist index=cityid
insert into coupon values (couponid,cityid)
end loop
</psuedo code>
HTH
Regards
Stephen
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
