Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Posts
    1

    Unanswered: Filemaker ODBC SQL problems

    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.

  2. #2
    Join Date
    Apr 2003
    Posts
    1
    I think you must be updating it using ODBC. I faced some other SQL error when I was posting date from the VB program into FM. I do not remember the exact error now, but I remember it got resolved by using {date} braces. Not sure if it helps.

    MSW

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •