Click here to Skip to main content
16,016,229 members
Home / Discussions / Database
   

Database

 
GeneralRe: Memory Leak! Pin
Mike Dimmick28-Oct-03 3:00
Mike Dimmick28-Oct-03 3:00 
GeneralRe: Memory Leak! Pin
Kevin Gutteridge28-Oct-03 22:03
Kevin Gutteridge28-Oct-03 22:03 
GeneralRe: Memory Leak! Pin
Mike Osbahr28-Oct-03 3:38
Mike Osbahr28-Oct-03 3:38 
GeneralRe: Memory Leak! Pin
Kevin Gutteridge28-Oct-03 22:47
Kevin Gutteridge28-Oct-03 22:47 
GeneralHi All Pin
Venkatraman26-Oct-03 13:55
Venkatraman26-Oct-03 13:55 
GeneralSQL: finding out if a column is NULL /without/ downloading all the content Pin
moredip26-Oct-03 12:58
moredip26-Oct-03 12:58 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
Edbert P26-Oct-03 13:14
Edbert P26-Oct-03 13:14 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
moredip26-Oct-03 13:22
moredip26-Oct-03 13:22 
Hi Edbert, thanks for the reply.

I'd thought of that, but I'm not sure how well it works if I'm displaying info about /every/ row in the table. I'd have to do a SELECT for each row. Plus, each row has about 5 different text fields (each 'page' of content has 5 'sub-pages'). So that would mean 5*num_rows SELECTs!

I guess a similar approach would be to initially do the SELECT you suggest (for each of the 5 content columns), and then programmatically compare each id to the results. Hmmm, maybe that's what you meant in the first place.

It's annoying that there doesn't seem to be a 'cleaner' way to do it, but then I guess SQL isn't really the most powerful thing for this kind of problem...

Thanks for you help,

Pete
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
Edbert P26-Oct-03 15:15
Edbert P26-Oct-03 15:15 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
Scott.Chappel27-Oct-03 1:54
Scott.Chappel27-Oct-03 1:54 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
moredip29-Oct-03 1:20
moredip29-Oct-03 1:20 
Generalduplication !! Pin
bora3ee26-Oct-03 11:31
bora3ee26-Oct-03 11:31 
GeneralRe: duplication !! Pin
Edbert P26-Oct-03 13:31
Edbert P26-Oct-03 13:31 
QuestionADO.NET: Is it possible to create a dataset out of a view? Pin
Rakesh Rajan26-Oct-03 1:15
Rakesh Rajan26-Oct-03 1:15 
QuestionHow to return a boolean value from a Stored Procedure? Pin
sacoskun25-Oct-03 3:38
sacoskun25-Oct-03 3:38 
AnswerRe: How to return a boolean value from a Stored Procedure? Pin
Paul Watson25-Oct-03 4:28
sitebuilderPaul Watson25-Oct-03 4:28 
QuestionWhy the connection is so slow? Pin
yyf24-Oct-03 8:46
yyf24-Oct-03 8:46 
AnswerRe: Why the connection is so slow? Pin
Paul Watson25-Oct-03 4:31
sitebuilderPaul Watson25-Oct-03 4:31 
AnswerRe: Why the connection is so slow? Pin
Rob Graham25-Oct-03 5:36
Rob Graham25-Oct-03 5:36 
AnswerRe: Why the connection is so slow? Pin
Mike Dimmick28-Oct-03 3:12
Mike Dimmick28-Oct-03 3:12 
GeneralQuery Pin
Anonymous24-Oct-03 3:08
Anonymous24-Oct-03 3:08 
GeneralRe: Query Pin
Rocky Moore25-Oct-03 4:34
Rocky Moore25-Oct-03 4:34 
GeneralRestore Pin
Anonymous22-Oct-03 9:32
Anonymous22-Oct-03 9:32 
GeneralRe: Restore Pin
Terry O'Nolley25-Oct-03 15:02
Terry O'Nolley25-Oct-03 15:02 
GeneralCreate an text field in Access from SQL Pin
Jerome Conus22-Oct-03 3:55
Jerome Conus22-Oct-03 3:55 

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.