I am still learning how to do this. I have created a sql statement inside of my code to look up a list for example location. I am not sure how to replace the...
Basically you just remove the constraint on the one location, but add that field to the order by clause as the first field so the names get grouped by...
Oooops, missed removing the "where" select location, firstname, lastname, employeenumber from xyz order by location, lastname -tom ... From: "mallard"...
I am so sorry but I think I was not clear. When a user logs in with their username and password, they should only see the list of locations that are assigned...
I don't know your db setup but I suspect you're looking in the wrong places? If the location table that you're querying already has the user name then why not...
OK, you have to tell us what tables are involved if you really want an answer, we're just guessing. But, it has to have more than one table for this, a...
AND I'd suggest letting us know if location info is in one text file as an array/list, or is it in multiple rows in a database that may be integer or text...
Tammy, it's usual to publish the solution so we can learn from it as well, could you please do that? Thanks, tom mallard .net web apps - project mgmt consumer...
This is actually a classic ASP question but I think the VB would be almost the same if someone doesn't mind helping me out. I am storing the list of company id...
I am using ASP Upload to upload images. I have some checkboxes as part of the form to allow the users to choose some options. When I upload the form,...
... It's probably returning a collection that you need to loop through, haven't used it in a while, to find out I try stuff, they have either a length or count...
I will check that out, but I don't think that it is returning a collection. I tried writing out the string, and it only returned the first box checked. I think...
OK, I think you just need to add another form on the page with your checkboxes, that should deliver them like before, may need to declare the page a multi-part...
I have never had to do that. I have to leave the layout of the page the same. Do I put the new form inside of the current form, or how do I do it? Thanks...
Without seeing the code it's hard to answer that ... you can't nest forms, they have to be separate but they post at the same time to the same place. If you...
Hi there, I'm new to this group and i hope my 5 years of experience on asp will help some of you. In my opinion, you can simply hide your emails by using...
I am stuck on this one. I have some code that needs to perform the following: if the number is more than 5 it goes to testenew form; if it is less than 4 then...
Where are you setting Session("Number" ) ? I don't see it. You need to wrap this up in an if/else statement, kind of like this: If Session("Number" )...
... Nope. You've got a number of things omitted: 1. you are retrieving rs.Fields("number"), but you are testing a Session variable of that name. Where do you...
Sorry if this isn't the correct place to post this, but I want to be able to do this with asp. I have a database that lists a few different flash animations. A...
I think you need to pass in the page url to the flash as a parameter and have the link activate from there since the animation is where the user is clicking....
All, I have been a very silent member of this group for a while now. I joined this group when I was developing an informal Access database with access on a...
Well, now. I have a large extranet application running on SQL Server, using Classic ASP, and it works "just fine" - but I don't use Ajax and have not...