Re: Problem passing empty form fields to access parameter query


"Mike Brind" <paxtonend@xxxxxxxxxxx> wrote in message
news:OEFRpC$QHHA.1200@xxxxxxxxxxxxxxxxxxxxxxx



However, if I change the row of

param_minvalue = ""

to

param_minvalue = "0"

or make sure that the number parameter contains any number, the
parameters are passed correctly and runs properly.

Obviously the param_minvalue "get lost" on the way, and is not
delivered as Null to the database.

What am I doing wrong?

One other thing, param_minvalue is never going to be null.

<% param_minvalue="" %>

stops it being null. It now has a value - that of an empty string.


.

Relevant Pages

  • UI - Period.
    ... > non-MV world without changing how the database is organized. ... > for-free libraries like the D3 Class Library and simple wrappers like ... and intuitive collection of 'stuff'. ... remains the power is lost; ...
    (comp.databases.pick)
  • Warning - Manual rebuild of database loses lots of data
    ... I reported that my Entourage database showed symptoms of corruption ... I exported all items from my 2008 database to an Entourage archive (.rge ... Diane has probably not tested her instructions on an IMAP account. ... Entourage preferences were lost and had to be re-entered. ...
    (microsoft.public.mac.office.entourage)
  • Re: What happens when you lose Log files before shutting down EX Srv?
    ... then the database will mount and transactions ... that were in the logs will be lost. ... The reason why the logs exist is to make sure that the database is ALWAYS ... >>what happens if you lose a log disk. ...
    (microsoft.public.exchange.admin)
  • Need Help with connecting to a database
    ... Database and I've tried so many things that I'm completely lost. ... What I need to do is access a set of btr files using SQL because there are ... I have a service app that starts a second app once a day. ...
    (borland.public.delphi.database.ado)
  • Re: MS Visual Basic - Error Accessing File
    ... Network connection may have been lost." ... Sure sign is that dreaded "Network Connection ... You might try importing everything into another database. ... - Open Form/Report in design view and select menu option View> Code ...
    (microsoft.public.access.modulesdaovba)
Loading