Search results for query: *

Thanks! Couldn't figure it out first because the drop down had an option selected when the page first loaded, but then realised that there was just an <option> tag left out above. Much apppreciated.

Thanks for your reply. I'm not too clear about two parts of your code: 1) action=&quot;<%= Request.ServerVariables(&quot;SCRIPT_NAME&quot;) %>&quot; method=&quot;post&quot;> 2)If Request.TotalBytes > 0 Then ' Or this could be If Request.Form(&quot;Sort&quot;) <> &quot;&quot; Then Sort =...

I have search that gets input from 3 drop-down boxes and one text box. The results of the search are displayed 5 at a time and therefore I need the results of the search to be displayed in the drop-down box as the user pages through the search results. At the moment I have am using...

Don't think that we're quite understanding each other! What I have is a specialisation, Problem being the superclass and the different problem types the subclasses. There are a number of fields common to each problem and then each problem has a problem type and the attributes applicable to...

Thanks James, don't think that would be the most efficient solution though as it would mean a lot of duplication of the problem attributes which is what I am trying to get away from. I am sure that there is a very simple solution to this, just wish that I knew what it was!!!!

Nope, the three tables are different, for each problem type there are different attributes that need to be stored so can't put them together. Don't think that the three columns in Problem would work either because that would,'t ure that each problem only has one problem type. Think that I'll...

I think that I'm confusing myself here! I have a problem table and a table for each problem type ie. one for batch, one for online and one for system. A problem can only be of one problem type, and a problem type can be associated with many problems.

No problem. Not quite sure that is the solution or else I'm not understanding completely! How would the problem type table link up to the tables for the different problem types? For example, the Batch table has the attributes procedure and program which could be different for every problem.

Thank you, that makes more sense. I have created table ProblemType with the key being ProblemID and having ProblemTypeID as an attribute and created a 1-1 relationship with Problem. Then I have created a 1-many relationship with ProblemType and the other tables using ProblemTypeID which is...

I have a table 'Problem' and each problem has a specific problem type. The problem types each have different attributes and so I have created a separate table for each one (there are 3:batch, online and system). I have a the primary key for Problem (ProblemID) as a promary key for each of the...

Thanks!

I am writing a search page that shows n results at a time and am having problems with sending variables to a HTML tag inside a 'Response.write'. Any ideas on the syntax? This is what I have so far: Response.Write(&quot;<INPUT TYPE=BUTTON VALUE=NEXT...

Got it figured out. The following code works for the update query: 'update row by row, columns a,b,c Dim sysno for i = 1 to countsys 'update systems table tSQL = &quot;UPDATE [Systems] SET&quot; tSQL = tSQL & &quot; Systems.[System] =...

I don't think that the semi colons are the problem, the same error is given with them in. UPDATE [Systems] SET Systems.[System] = 'CICS', Systems.[Description] = '', Systems.[Responsible] = '' WHERE (Systems.[SNo]) = 5 AND (Systems.[System])=6; UPDATE [Systems] SET Systems.[System] = 'MQ'...

Yip, when I response.write, this is what I get: UPDATE [Systems] SET Systems.[System] = 'CICS', Systems.[Description] = 'crap', Systems.[Responsible] = '' WHERE (Systems.[SNo]) = '5' AND (Systems.[System])=6UPDATE [Systems] SET Systems.[System] = 'MQ', Systems.[Description] = 'fhfhfghfgh'...

I am trying to update the values in an ASP page read from a database. The values are stored in a table with the columns labeled from a-c (d is a hidden column containing the promary key) and the rows are from 1 to countsys which is a variable storing the number of systems. The error that I get...

Thank you! Knew that it had to be something REALLY simple!!! Bree

I am displaying information from a database and allowing the user to edit it and then submit the changes. The problem is with the text box as when the page is displayed and the user clicks on the text box, the cursor is placed at the BEGINNING of the text (as opposed to at the end) and the user...

Thanks! That solved the second question! Regarding the first question, I have a table listing different areas and then another table inside each row of the first table listing the systems for each area. When 'view' is clicked on in ANY row in the main table, this action is applied to the...

Thanks for your help. It still doesn't work 100% though. There are two problems: 1) Clicking on 'View' only works for the first row in the table so that clicking on 'view' in any other row in the table displays/hides the information in the first row! 2) I would like the information NOT to...