Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by sgraham

  1. sgraham

    Server Behavior: Show if dataset NOT empty

    [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...
  2. sgraham

    Server Behavior: Show if dataset NOT empty

    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...
  3. sgraham

    Server Behavior: Show if dataset NOT empty

    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...
  4. sgraham

    Server Behavior: Show if dataset NOT empty

    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...
  5. sgraham

    Expression='<%# (ds_fin.RecordCount > 0) %>'

    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
  6. sgraham

    Expression='<%# (ds_fin.RecordCount > 0) %>'

    What causes this number to increment to 1 or more?
  7. sgraham

    Server Behavior: Show if dataset NOT empty

    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...
  8. sgraham

    Selecting Column Names for use in a query

    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...
  9. sgraham

    Selecting Column Names for use in a query

    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??
  10. sgraham

    Selecting Column Names for use in a query

    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...
  11. sgraham

    Selecting Column Names for use in a query

    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)
  12. sgraham

    Selecting Column Names for use in a query

    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
See more

Part and Inventory Search

Back
Top