Hi:

When I run this query through my php program it bombs with the following error:

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 15., SQL state 07001 in SQLExecute in c:\inetpub\wwwroot\chamber\Add\customer_add_script.php on line 29

When I paste my query into Access, it runs w/o problem:

insert into table1 values("9", "asdf", "asdfasdf", "ddddddd", "33333", "4444", "eeeeee", "asdfasdf", "gggggg", "VA", "33333", "5555", "66666", "3333", #01-01-1999#, "888", "9999", "000000")

Anyone have any ideas?

    Didn't fix it. Well, at least what I tried didn't work:

    \"#$joindate#\"

    #$joindate# didn't work either....any more ideas?

      try a simple query to a simple test table with one column and see what happens.

      you might need to replace the double quotes with single quotes.

        Write a Reply...