Click here to Skip to main content
15,901,035 members
Home / Discussions / Database
   

Database

 
AnswerRe: subquery using 1 table Pin
Aadhar Joshi16-Oct-12 20:28
Aadhar Joshi16-Oct-12 20:28 
GeneralRe: subquery using 1 table Pin
john john mackey17-Oct-12 4:38
john john mackey17-Oct-12 4:38 
QuestionHigh Number of Lock Requests Pin
cjb11016-Oct-12 3:23
cjb11016-Oct-12 3:23 
AnswerRe: High Number of Lock Requests Pin
Eddy Vluggen17-Oct-12 0:17
professionalEddy Vluggen17-Oct-12 0:17 
QuestionSQL Select Where query Pin
Joe Stansfield15-Oct-12 0:37
Joe Stansfield15-Oct-12 0:37 
AnswerRe: SQL Select Where query Pin
Eddy Vluggen15-Oct-12 0:57
professionalEddy Vluggen15-Oct-12 0:57 
GeneralRe: SQL Select Where query Pin
Joe Stansfield15-Oct-12 1:15
Joe Stansfield15-Oct-12 1:15 
GeneralRe: SQL Select Where query Pin
Eddy Vluggen15-Oct-12 1:22
professionalEddy Vluggen15-Oct-12 1:22 
Joe Stansfield wrote:
The problem is when it doesn't match a stored record. Will using the query as above with ISNULL work?

Dunno - it will not return an empty record, but it'll return '1' when the value is empty. Would that work with the rest of your code?

Joe Stansfield wrote:
And if so, am I right in assuming that the query first executes the where part of the query, then the IFNULL portion and, if still valid after that, retrieves the correct record?

Yes.
Bastard Programmer from Hell Suspicious | :suss:
if you can't read my code, try converting it here[^]

GeneralRe: SQL Select Where query Pin
Joe Stansfield15-Oct-12 1:28
Joe Stansfield15-Oct-12 1:28 
AnswerRe: SQL Select Where query Pin
Eddy Vluggen15-Oct-12 2:15
professionalEddy Vluggen15-Oct-12 2:15 
GeneralRe: SQL Select Where query Pin
Joe Stansfield15-Oct-12 10:48
Joe Stansfield15-Oct-12 10:48 
GeneralRe: SQL Select Where query Pin
fjdiewornncalwe15-Oct-12 11:06
professionalfjdiewornncalwe15-Oct-12 11:06 
GeneralRe: SQL Select Where query Pin
Joe Stansfield16-Oct-12 0:08
Joe Stansfield16-Oct-12 0:08 
GeneralRe: SQL Select Where query Pin
Eddy Vluggen16-Oct-12 0:12
professionalEddy Vluggen16-Oct-12 0:12 
GeneralRe: SQL Select Where query Pin
Joe Stansfield16-Oct-12 23:04
Joe Stansfield16-Oct-12 23:04 
GeneralRe: SQL Select Where query Pin
Eddy Vluggen16-Oct-12 23:37
professionalEddy Vluggen16-Oct-12 23:37 
GeneralRe: SQL Select Where query Pin
Member 952116716-Oct-12 22:41
Member 952116716-Oct-12 22:41 
GeneralRe: SQL Select Where query Pin
Simon_Whale16-Oct-12 22:52
Simon_Whale16-Oct-12 22:52 
GeneralRe: SQL Select Where query Pin
Rohit Shrivastava18-Oct-12 7:56
Rohit Shrivastava18-Oct-12 7:56 
GeneralRe: SQL Select Where query Pin
Joe Stansfield15-Oct-12 1:20
Joe Stansfield15-Oct-12 1:20 
GeneralRe: SQL Select Where query Pin
Eddy Vluggen15-Oct-12 1:25
professionalEddy Vluggen15-Oct-12 1:25 
AnswerRe: SQL Select Where query Pin
Nidhisha Biju15-Oct-12 1:05
Nidhisha Biju15-Oct-12 1:05 
GeneralRe: SQL Select Where query Pin
Eddy Vluggen15-Oct-12 1:26
professionalEddy Vluggen15-Oct-12 1:26 
AnswerRe: SQL Select Where query Pin
Aadhar Joshi16-Oct-12 20:47
Aadhar Joshi16-Oct-12 20:47 
AnswerRe: SQL Select Where query Pin
Hitesh R23-Oct-12 1:06
Hitesh R23-Oct-12 1:06 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.