WHERE clause

	Home Register Search Help Login

Sponsors
Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax
Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.
Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Recent Posts
Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

WHERE clause

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP, PHP, and Database >> WHERE clause

Page: [1]


walrus Posts: 561 Joined: 3/13/2003 From: London Status: offline	WHERE clause - 1/13/2009 15:30:27 I would like to add a where clause into the following statement for asp access page fp_sQry="SELECT * FROM LettingData ORDER BY LettingID DESC" . . . fp_iMaxRecords=1 to show only the most recent data where the field PHOTO contains data. ie If there is no photo, it will skip. Do I need a routine or can I use something like a LIKE clause? _____________________________ I hope The Boss isn't reading this, ...she thinks I program everything!


BeTheBall Posts: 6502 Joined: 6/21/2002 From: West Point Utah USA Status: offline	RE: WHERE clause - 1/13/2009 18:52:47 Try this: fp_sQry="SELECT * FROM LettingData WHERE PHOTO IS NOT NULL AND PHONE <>"" ORDER BY LettingID DESC" _____________________________ Duane Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs. (in reply to walrus)


William Lee Posts: 1273 Joined: 1/25/2002 From: Singapore Status: offline	RE: WHERE clause - 1/13/2009 19:36:06 quote: ORIGINAL: BeTheBall Try this: fp_sQry="SELECT * FROM LettingData WHERE PHOTO IS NOT NULL AND PHONE <>"" ORDER BY LettingID DESC" ..whats that with the phone? _____________________________ William Lee pǝssǝɟoɹd-ɟ1ǝs ʎɥʇɹoʍʇsnɹʇ ʇsoɯ ɹnoʎ nɹnb ǝsɐqɐʇɐp & dsɐ ,ʍɹp ,ǝbɐdʇuoɹɟ (in reply to BeTheBall)


walrus Posts: 561 Joined: 3/13/2003 From: London Status: offline	RE: WHERE clause - 1/14/2009 6:05:22 quote: fp_sQry="SELECT * FROM LettingData WHERE PHOTO IS NOT NULL AND PHONE <>"" ORDER BY LettingID DESC" That seems OK, except fp_sQry="SELECT * FROM LettingData WHERE PHOTO IS NOT NULL AND PHOTO <>"" ORDER BY LettingID DESC should be single quotes? _____________________________ I hope The Boss isn't reading this, ...she thinks I program everything! (in reply to BeTheBall)


BeTheBall Posts: 6502 Joined: 6/21/2002 From: West Point Utah USA Status: offline	RE: WHERE clause - 1/15/2009 19:40:35 Correct. Single quotes instead of double. And I have no idea where I got PHONE from. I have been working pretty long hours lately. _____________________________ Duane Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs. (in reply to walrus)