Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2325
  • Last Modified:

odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.

I have a client that is running PHP script to update some pricing and item descriptions in an SQL database.  Since we moved the Access database to a new server, we have been having problems.  I have completely redone the ODBC for this app and all the other components are working except this one.  I can't imagine anything else has changed that would cause this error.  It was working fine before we moved the database and once we re-established the ODBC all other components of this web frontend are working except this one.
Error Message:
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1., SQL state 07001 in SQLExecDirect in C:\wamp\www\ItemUpdate\UpdateItemDescriptions.php on line 113

Code:starting at line 112;  $connect1 is defined earlier in the code and seems to work in the other PHP script

$query1 = "SELECT RefNum,SHORT_DESCRIPTION FROM AllPrices ORDER BY RefNum";
$result1 = odbc_exec($connect1,$query1);

$itemcount=0;
while (odbc_fetch_row($result1)) {
  //put the data into an array; we'll pop the data later if it is the same in the Inventory system
  $itemref = odbc_result($result1,"RefNum");
  $itemdesc = odbc_result($result1,"SHORT_DESCRIPTION");
  $pbArray[$itemref] = $itemdesc;
  ++$itemcount;


thanks for the help


0
chenault68
Asked:
chenault68
1 Solution
 
darren-w-Commented:
Hi,

it may be something to do with how your ref number is being added?

try echoing  the $query1 line out before issuing the call and copy the calling line into you sql client to see if it works.
0
 
chenault68Author Commented:
Thanks for the help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now