SQL Database results follow up

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Lost but not as much (anonymous_at_discussions.microsoft.com)
Date: 04/27/04 

Date: Tue, 27 Apr 2004 11:49:08 -0700

Thanks to many of you and this group, I have solved 99% of
my problems. The latest was a corrupt global.asa file.

Only one issue remains.

I have the simplest of queries against a SQL table:

SELECT * FROM database1_fn WHERE (f_docnumber
= ::f_docnumber::)

f_docnumber is the key field in a SQL table. Nulls are
not allowed. The field is configured as Numeric 9(10,0).

This is on a page that allows the user to enter a
f_docnumber to search for in the database. The following
error appears on the page BEFORE any entry is made.

Database Results Error
Description: Line 1: Incorrect syntax near ')'.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for SQL Server

One or more form fields were empty. You should provide
default values for all form fields that are used in the
query.

If I enter a number, the query works perfectly.

I have tried populating the query with a default value of
a valid f_doccumber but the error remains.

I am assuming that the :: signifies a form search field.

Where else should I be looking?

Thanks

Relevant Pages

  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: complex filter and calculations in access
    ... switch to SQL view. ... query by switching to datasheet view, ... of your database using the from address in this post. ... pre-op infections yes/no ...
    (microsoft.public.access.queries)
  • Re: A little more meat this week
    ... implementation with a query processor capable of returning a result set ... then we can call it a result bag (SQL ... I'm looking at the data model and not database tools at this ... for a s/w developer and a s/w developer simplifies for the end user). ...
    (comp.databases.pick)
  • Re: complex filter and calculations in access
    ... when using a subquery on the same table as the main query, ... switch to SQL view. ... of your database using the from address in this post. ...
    (microsoft.public.access.queries)
  • Re: A little more meat this week
    ... said data includes lists." ... implementation with a query processor capable of returning a result set ... then we can call it a result bag (SQL ... I'm looking at the data model and not database tools at this ...
    (comp.databases.pick)