Click here to Skip to main content
15,847,653 members
Home / Discussions / Database
   

Database

 
GeneralRe: Problem in using OleDbDataReader Pin
sivaramakrishna7-Nov-03 20:06
sivaramakrishna7-Nov-03 20:06 
Generaldbo Pin
Hugo Hallman5-Nov-03 13:19
Hugo Hallman5-Nov-03 13:19 
GeneralSQL! Pin
Silly Boy5-Nov-03 7:18
Silly Boy5-Nov-03 7:18 
GeneralRe: SQL! Pin
Jeff Varszegi5-Nov-03 8:34
professionalJeff Varszegi5-Nov-03 8:34 
GeneralRe: SQL! Pin
andyharman5-Nov-03 12:49
professionalandyharman5-Nov-03 12:49 
GeneralEncoding problem using ADO Stream Pin
Firas Rashid4-Nov-03 3:59
Firas Rashid4-Nov-03 3:59 
GeneralAlternative SQL Queries based on Table Data Pin
Jo Fredrickson3-Nov-03 22:58
Jo Fredrickson3-Nov-03 22:58 
GeneralRe: Alternative SQL Queries based on Table Data Pin
andyharman5-Nov-03 12:35
professionalandyharman5-Nov-03 12:35 
Sub-selects can only ever return a single value if used in the way that you have tried. If you absolutely need to meet your requirements with a single SQL statement then you may try something like:
SELECT ...
WHERE (SELECT PropertyValue FROM PropertyTable
    WHERE PropertyCode=10)=0)
UNION ALL
SELECT ...
WHERE (SELECT PropertyValue FROM PropertyTable
    WHERE PropertyCode=10)<>0)
ORDER BY ...
The first select returns a resultset if property 10 does not exist, otherwise the second select returns its resultset. Note that both resultsets must return the same number of columns, with the same datatypes.

Hope this helps.
Andy
GeneralRe: Alternative SQL Queries based on Table Data Pin
Jo Fredrickson5-Nov-03 15:59
Jo Fredrickson5-Nov-03 15:59 
GeneralMSADO 2.5 Pin
Kant3-Nov-03 16:46
Kant3-Nov-03 16:46 
GeneralRe: MSADO 2.5 Pin
Mike Dimmick5-Nov-03 2:51
Mike Dimmick5-Nov-03 2:51 
GeneralRe: MSADO 2.5 Pin
Kant5-Nov-03 6:01
Kant5-Nov-03 6:01 
GeneralFULL LEFT/RIGHT JOIN Pin
devvvy3-Nov-03 13:53
devvvy3-Nov-03 13:53 
GeneralRe: FULL LEFT/RIGHT JOIN Pin
Jeff Varszegi3-Nov-03 15:28
professionalJeff Varszegi3-Nov-03 15:28 
GeneralRe: FULL LEFT/RIGHT JOIN Pin
devvvy3-Nov-03 15:30
devvvy3-Nov-03 15:30 
GeneralTrouble Running Sql Script from Code Pin
perlmunger3-Nov-03 12:42
perlmunger3-Nov-03 12:42 
GeneralRe: Trouble Running Sql Script from Code Pin
Jeff Varszegi3-Nov-03 15:54
professionalJeff Varszegi3-Nov-03 15:54 
GeneralRe: Trouble Running Sql Script from Code Pin
perlmunger4-Nov-03 4:58
perlmunger4-Nov-03 4:58 
GeneralRe: Trouble Running Sql Script from Code Pin
Jeff Varszegi4-Nov-03 5:03
professionalJeff Varszegi4-Nov-03 5:03 
GeneralRe: Trouble Running Sql Script from Code Pin
perlmunger4-Nov-03 5:54
perlmunger4-Nov-03 5:54 
GeneralRe: Trouble Running Sql Script from Code Pin
Jeff Varszegi4-Nov-03 6:38
professionalJeff Varszegi4-Nov-03 6:38 
GeneralRe: Trouble Running Sql Script from Code Pin
perlmunger4-Nov-03 7:55
perlmunger4-Nov-03 7:55 
GeneralIdentity Seeds Pin
Colin Angus Mackay3-Nov-03 7:56
Colin Angus Mackay3-Nov-03 7:56 
GeneralHandling Disconnected Data In ADO.NET Pin
L Thomas3-Nov-03 6:10
L Thomas3-Nov-03 6:10 
Generalsql tables Pin
ranjjj31-Oct-03 4:14
ranjjj31-Oct-03 4:14 

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.