here is my code:

<cfset listcount = 0>

   <CFQUERY datasource="DWS_product_catalog">

    Insert Into option1values(ProdID, myValue)

    <cfloop list="#form.option1values#" index="currentValue" delimiters="#chr(13)#">

   <cfset #variables.listcount# = #variables.listcount# + 1>

   select #url.prodID#, '#Left(Ltrim(currentvalue),30)#'

   <CFIF #variables.listcount# LT #listlen(form.option1values, chr(13))#>

     union all

   </CFIF>

   ...

ok so here's another interesting development - all the values entered into the database are the same length at the first value.

so for instance i entered the following values:

Large

Medium

Small

Extra Large

the...

ok so i tried insertign the explicit values and it worked fine - so it must be a problem with the variables.  i just cant understand what.

yeah prodID is the same for all rows.  the values being used are variables but i am able to view the actual SQL query beign generated and it is exactly...

well i am using a textarea to collect the list values (one item per line) so there is no maxlength attribute for the a textarea.

and the datatype is definitely varchar(30)...

ok so it is sort of working:

my generated query looks like this:

Insert Into option1values(ProdID, myValue)

select 10, 'Red'

union all

select 10, 'Green'

union all

select 10, 'Blue'

union all

select...

ok so my table consists of 3 fields:

ID - autonumber, PK

ProdID - int, FK

MyValue - varchar 100

i am using ColdFusion to work with this table so if i had 3...

yeah that might do it - lemme try.

ok - i think i got all my data imported - thank you everyone for all your help - there is a lot of great info in this thread.

what i...

ok i guess there is something i am not understanding here.  my eventual goal is to have a table consistign of all the good records with their dates in a...

ok so what if i just delete the data i have imported to the staging table and create a new DTS package from the import wizard which uses a SQL...

tague - i got my DTS package setup with the MS OLE DB connection and the Execute SQL Task.  but when i run it i get the followign message:

The Statement...

what other information do you need to help me skip the "deleted" records?

unfortunately no - we don't have a fox pro person available.  the person who created our fox pro apps left us long ago and now it is up to me...

so doing this would log all the errors but what woudl it do when it encounters a row with errors?  skip it?