I have a form that passes information to another form. In the second form I have the DRW insert the data into the table. (i have this working)my problem is that I also have the second form calculating a couple values and i also want to add tehm to the table.
I can edit the asp file manually and get it to work. I was wondering if any one knows how to do it in the DRW in custom query.
Here is what i need
INSERT INTO tblMediaData (MediaType) VALUES ('"&MediaType&"')
Here is what FP gives me
INSERT INTO tblMediaData (MediaType) VALUES ('""&MediaType&""')
I dont need the other set of double quotes.
Any Ideas or suggestions?
Thanks,
Bill