JanetMoore
02-13-02, 15:02
| I'm using Win32::ODBC mod in an ASP page. I'm having problems with the sql function $sql = "INSERT INTO WhereUsedRCV.fp5 ( WURequest, CaseID, ". "RCVxMaterial_Description, MaterialChecked) " . "VALUES (\'$WURequest\', \'$CaseID\', \'$RCVxMaterial_Description\', \'$mat\')"; $db->Sql($sql); In the field $RCVxMaterial_Description a list of part numbers are being entered in the following format: DOC ONLY Material 0001234567 1234567890 9876543210 The above works fine unless I get a part number with the following: DOC ONLY Material 012345-9999 987654-1234 How do I handle the hyphen? I've tried escaping it and various other methods but I keep getting an ASP 0115 error which brings down IIS. Any ideas on what I can do? Thank you very much. |