Recent content by sgraham

[smile] I think the req_type & dep_nameShort were an attempt to feed my newbie paranoia that everything would be ok... Thanks for all the help and the tips! I think I'll remove the req_type & dep_nameShort from all but the first table, and use the JOIN to tie everything together as you...

I should probably start a new topic for this, but what do you think of the following database layout? create table supportRequest_ID ( req_id int not null primary key IDENTITY(1,1), req_type char(3) not null check(req_type in('HDR', 'SCR', '400'), dep_nameShort char(3) not null...

Yes, actually I could and should have a seperate linked table for that information. I've come to realize my biggest problem is me, or more specifically the way I designed the database, so I've been contemplating redoing the database in order to creat a seperate linked table for each department...

Thank you SO MUCH for the help! I've still got one security group that wants to show up when it's not supposed to but all the others are behaving like they should. bluetone: Thanks for the tip. I'm currently teaching myself php in an attempt to replace the vb.net code, and I'm sure I'll be...

So do I understand this correctly? If no records are returned the number stays at 0, but if records are returned the number is incremented to 1

What causes this number to increment to 1 or more?

Hello everyone, thanks for taking a look and possibly helping me solve this headache. I'm using DMX 2004, SQL 2000, and VB.NET I've setup an Intranet page using a simple form and a textbox to search for a specific security change request. This page has multiple datasets, one for each...

Wow - That's some piece of code! With a bit of customization, adding a column or two, it’ll be able to do everything I need. Thanks so much for hand holding me; this has been an education to be sure! Thanks to DotNetGnat & amrita418 as well. Each of you has given me much to look at and learn...

Ugg, I don't know... none of the idea's I'm having seem to pan out (mostly because I don't really know how to use SQL). Is there a way to select the data in the column similar to information_schemas.columns? something like information_schemas.columns.data??

btw juice, What I'm trying to do is dynamically select only the column names that have actually been given the value of 'grant'. The solutions provided thus far have worked wonderfully, but are only step one. Step One: Select the column names - done. Step Two: Select only column names where...

Thank you very much! I'm working/reading through the code and links you've given me and learning a lot, however, I'm still having trouble with selecting only the column names that have a value of 'grant'. I'll post my final solution when I find it. Thanks again :0)

How do I select the column names from a DB? I'm looking to do something like: SELECT * FROM db1 WHERE column_name like 'Z%' AND column_value = 'grant' If you could educate me on this I would appreciate it. Thanks for you time, Steve Graham Beginner