VBScript variables into fp generated sql statement - 8/1/2001 13:45:00
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
|