Search results for query: *

I have a form in a pop up window, but when I submit the form, it it opens up the results in a new IE window. Does anyone know how id go about submitting the form to the same pop up window?

I have a piece of HTML code with Javascript tags which were working fine until i renamed the file .asp and added some asp code. The error I'm getting when loading up this page is Active Server Pages error 'ASP 0138' Nested Script Block Line 12 A script block cannot be nested inside another...

Hi does anyone know what the best way is to have a list of links a-z which then in turn list the values of a column in a DB. For instance say my column has 5 values (abba,bacon,croutons,deer,egg) I want some links like this. So if I was to click 'a' the web page would bring up "abba"...

through SQL or if not SQL, any other method ? Our EPOS system is DOS based and currently only allows us to maintain one price file (for over 150 branches). We're going to change this to allow us to have regional price files (11 of them). The EPOS system uses a Btrieve database which nobody...

I would like to know if there are any triggers associated with a table.... is there anyway of doing this please?

Hi, I need to create a duplicate record of a record in my database and insert it with a new ID. The ID is an identity field so that will increment once the record is inserted anyway so I guess I just need the SQL that will do this. The only information I have is the ID of the record I want to...

Does anyone have a decent set of ASP functions which make it easier to interact with databases. So for instance I would call a function which would connect to a db, execute a stored procedure and return a recordset which I could then work with.

I have a web page which sometime allows duplicate entries of user submissions. Rather than restrict this at the database level, the client has asked for a report to list the User Id's(Identity field) of all duplicate records. Now here is the problem. I am using this SQL to grab my records...

I would like to loop through the form elements and test to see where the 3rd character of the ID name is a "3". if TheElem[i].id.CharAt(2) == 3 Can I simply just do this?

Hi I have a form which has about 50 check boxes. However some of those checkboxes are between a divtag of id=childrensgroup. Is there any way in Javascript that I can click a checkbox called "Select all checkboxes in the childrens group" outside the DIV tag which will then select all the...

I have a series of questions on a page each question has 3 radiobuttons. The number of questions on a page is dynamic and also the name of each group is dynamic as well depending on the id genrated from the DB. I need some code which will loop through each group of radio sets and make sure that...

I am joining 3 tables together although when there are no matching results in the contributor table nothing is retuned for the whole record set. I would like the firstname and lastname to just say null if there is nothing in them. Can anyone help? SELECT E.EventID, E.Title...

Hi guys... I need to be able to initially hide a dropdownbox on the load of a page. However there are a set of check box options and if the user clicks one of the check boxes I need the menu to appear. Is this difficult? Can someone help me out or maybe point to some code that might do the...

Hi.... I need to trap errors in my ASP code. I understand that there are 2 types of errors in ASP. Database errors and Page errors, so i have written some code to trap both and print them to the screen. [code] 'Error Handler If Err.Number <> 0 Then 'Clear response buffer Response.Clear...

Hi... I have 2 executes to the database, one is a delete and the other is an insert. The delete is first and the insert directly after. I would like to put in some rollback feature which will allow any changes made to the db to be rolled back if something goes wrong. 'delete all user...

I have a set of user interests which can be set by a set of checkboxes. These interests ID's are then submitted to a database, which is fine. The problem I currently have though is how do I repopulate those checkboxes on my form when the user goes to amend his profile. the code i have so far is...

Hi I Need to output my recordset data in a specific way. I have 2 columns, Customer and Region. There are 6 regions I need to display first the region and then loop through and list the customers. Region 1 - Customer - Customer - Customer Region 2 -Customer -Customer -Customer -Customer...

When trying to execute this code, specifically Response.Write(strCheckBoxSubscript) the following error is returned Response object error 'ASP 0106 : 80020005' Type Mismatch /login/calendarchanges.ex.asp, line 0 An unhandled data type was encountered. For vItem = 1 to...

Im gettng this error Microsoft VBScript runtime error '800a0009' Subscript out of range: '[number: 2]' /login/calendarchanges.ex.asp, line 25 when I run this code Dim x Dim intFieldCount Dim aryCalendarChangeIds() Dim strCalendarChangeIds Dim PageName PageName =...

I have a form which submits a mixture of hidden and checkbox from elements. Is there anyway of just looping through through the hidden elements on a form?