DBRW Criteria problem with spaces

[Appalachia]

++ Tried this in Programming, no Reply yet ++

Hi,

I have an Access Database that has a Field - City.

In that are various cities.

'Criteria' in DBRW will pull up a single word (e.g. Denver) but not multiple
words (e.g. New York)

I tried copying and pasting the actual field info in case the space was not
actually a space (?)

Tried quotes etc but still 'No Records Returned'

Any ideas?

Many thanks

A

 

[Thomas A. Rowe]

Please paste a copy of your query string.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================

 

[Appalachia]

Is this OK - an example page?

http://visitorsite.info/test.asp

A

 

[Appalachia]

Yes OK the example was a mistake...

Is this the line you need to see -
fp_sQry="SELECT * FROM Retail_data_visitorsite WHERE (City = '""Los
Angeles""') ORDER BY Zip DESC"


A

 

[Thomas A. Rowe]

Try the following:

fp_sQry="SELECT * FROM Retail_data_visitorsite WHERE City = 'Los Angeles' ORDER BY Zip DESC"

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================

 

[Appalachia]

Thanks

Tried your example.

FrontPage just changed it back to the original.

So I modified it in Notepad and yes it works.

Does that mean this is a limitation in the DBRW that can't be overcome?

A.

 

[Thomas A. Rowe]

I personally do use the DBRW, so I can't say as I hand write all of my code.

After making the change in HTML/Code View and save the page while in this mode.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================

 

[Appalachia]

Is it possible to remove the DBRW casing to just leave the ASP code?

Many Thanks

A.

 

[Stefan B Rusynko]

See http://www.outfront.net/spooky/adv_drw_diet.htm

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Is it possible to remove the DBRW casing to just leave the ASP code?
|
| Many Thanks
|
| A.
|
|
|
|
| "Thomas A. Rowe" wrote:
|
| > I personally do use the DBRW, so I can't say as I hand write all of my code.
| >
| > After making the change in HTML/Code View and save the page while in this mode.
| >
| > --
| > ==============================================
| > Thomas A. Rowe
| > Microsoft MVP - FrontPage
| >
| > http://www.Ecom-Data.com
| > ==============================================
| >
| >
| > | > >
| > > Thanks
| > >
| > > Tried your example.
| > >
| > > FrontPage just changed it back to the original.
| > >
| > > So I modified it in Notepad and yes it works.
| > >
| > > Does that mean this is a limitation in the DBRW that can't be overcome?
| > >
| > > A.
| > >
| > >
| > > "Thomas A. Rowe" wrote:
| > >
| > >> Try the following:
| > >>
| > >> fp_sQry="SELECT * FROM Retail_data_visitorsite WHERE City = 'Los Angeles' ORDER BY Zip DESC"
| > >>
| > >> --
| > >> ==============================================
| > >> Thomas A. Rowe
| > >> Microsoft MVP - FrontPage
| > >>
| > >> http://www.Ecom-Data.com
| > >> ==============================================
| > >>
| >
| >
| >

 

[Thomas A. Rowe]

Correction: I personally DO NOT

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================