Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is wrong in this code ?
Message
From
09/10/2001 15:53:15
Jason Dalio
Northern Interior Regional Health Board
Prince George, British Columbia, Canada
 
General information
Forum:
Internet
Category:
Active Server Page
Miscellaneous
Thread ID:
00561454
Message ID:
00566163
Views:
30
Regarding not wanting all of the records returned if you are only trying to do an AddNew:

I like using "SELECT data FROM myTable WHERE 0 = 1;"

Since 0 can never equal1 it won't return any rows. Also, you are dealing with a boolean compare so the resource i less (although the resource is fairly inconsequential).
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform