I have two tables, one called tblManufacturers and one called tblModels. tblManufacturers is already populated but now I have to enter the following models which correspond to the ID of the manufacturer into the tblModels table. Any ideas of how I can do this. Code:
I have an array which has days of the month stored in it. For example at one time it might have the values
1,2,3,6,7,8,9
at another time it might have the value
4,5,12,14,19,25
These are days of the month that have been selected and read into an array. What i would like to do is to write them out and put a "X" where the days were selected Code:
i m getting these value from a query n stored it in an array:
FY2005 P1 (8/1/2005 - 8/31/2005), FY2005 P2 (9/1/2005 - 9/31/2005) and so on. i need to use eg 8/1/2005 as startdate and 8/31/2005 as enddate similarly 9/1/2005 as startdate and ,9/31/2005 as enddate. and so on
we can split FY2005 P1 (8/1/2005 - 8/31/2005), FY2005 P2 (9/1/2005 - 9/31/2005) by using split func in vbscript. But how can we use its subparts.i mean 8/1/2005 etc ...
some ready-made code that will loop through the values in an array and sort them in ascending or descending order? I'm about to start building some new functionality that will need to sort the values in an array and then present them in ascending order. My initial thoughts are to loop through the initial array, find the lowest value and then load that value (and all associated values) into a new array.
I first retrieve the values stored in a session variable (where I have stored an array). Then I assign the session variable to a local array called "myarray".
Assume that "myarray" now contains 5 records. What would the code look like if I want to create a loop that transfers the 5 values from "myarray" into a select box/dropdown list?
I have 24 checkboxes all with the same naming convention, each box has a value ranging from 1 to 23, what I need to do is fill in the gaps with a 0 value where the user doesn't select a value.
So lets say that the user selects:
1,2,3,4,5,6,7,15,18,19,20
what I want to do is use the split function on the next page to convert into an array but then I want to redim the array and fill in the missing values, so I would end up with:
I know that cookies can store an array of values, which can be accessed like this:
tempid = Request("cookiename")(i)
Is it possible to use session variables in the same way? Store a array of values in the same session variable and access them on another page by indexing?
I've looked around alot and I've not found anything suggesting that this is possible.
Right now I'm using a single set of cookies to store info on a series of purchaces of the same type of item. I'm hoping to use session variables to replace the cookies.
Does anyone know for certain if this is not possible?
I have part of a keyword search function that is acting supernatural - I have a bubble-sort function that sorts the content of an array, then returns an array containing the item numbers of the original array, arranged in order according to their content. Code:
how to create an array of checkboxes that were selected from a form on one page and pass them into hidden fields in a form on the next page? I have this massive project I've been working on and am having trouble with this.
I am trying to filter a table of users to select only those records whose roleID matches a value in an array. There could be any number of IDs held in the array from one to a few hundred. The array is generated by splitting a comma delimited memo field from a second table in an Access DB. I can split the memo field OK, I can response.write its values, but what I now want to do is add a value from another table to my reponse write loop. Code:
I have this dynamic array(shown below) that I need to match to values (1 - 10) that I am returning from the database via DSN connection object.
The values I need to match are on the same page (in their own table) but I am not sure how to match up the array indexes to these values. I want to be able to display the array result as part of or nested in another table. Code:
if i have a vbscript function on a certain form and I assigned some values on an array variable on that function, is there a way for me to retrieve the values of that array on another asp page once i submitted the form?
I am using VBScript - (asp pages) I want the person to enter a Part Number into a field Example R3HAA0001-CP But the person may not know the whole Part Number and enter
Example 3HAA
I want to use a wild card to make sure the person gets the correct Part Number. I want to stay on the same screen, list the Part Number and Description - now if the person doesn't know the whole number and enters only a partial - I want all of the Part Numbers that match the criteria.
I have a database feild that I need to have html code entered into. Short of getting the clients the copy and paste code into <textarea>, is there a simple wysiwyg editor to do the job?? or another way?
I am having a problem with entering long ammounts of information (roughly 400 characters) into a database. The database field is set to memo.
Seems that whenever I want to enter strange characters it gives me an error. (I need to enter strange characters for an important reason).
Also I am having some problems with using ASP on Netscape (not testing...just clients are having problems). Does anybody have an idea of whats going on??
i try to make three textboxes to enter the date,but the problem is , when they enter the data base they enter like this 10,12,1980. so it will not be accepted by the date field
I would like to know if and how it would be possible to create an entry-screen that allows the user to enter data in a database, using a spreadsheet/table-like entry screen. The screen would start of having headers for each column/field and an empty row underneath. When each column in the row is filled in, the user must have an option to add another row.
I'm look for the code/explanation that helps me set up the entry screen, and the ASP code to add the entered data in the database.
I can imagine that each entered row is added to the table when a new row is added, or a button is pressed and then the screen refreshes with the newly entered information and a new row...
I have a page where the user logins in and is taken to another page. On this page i want them to insert data into another table within my database.
At the moment however it just enters data into the database once. I'm assuming it�s because I don't have a recordset set up. How do get the ID of the user so that it will insert the new data into the relevant recordset.
I have a few forms and find that people are intering all sorts of information into them that we dont want. Is there a way to stop people from entering things like ()*&^%$#@!+_=><"':; and so in into the forms.
A form example on the site is basic. Something like this.
i have a problem with an asp form on my workplace site. Spammers appear to be hammering it daily with requests, our form sends an automatic email, but the email addresses they enter are all fake "donotreply@whatever.com" which is causing a mountain of repeated mail delivery subsytem messages that run on for days. AVALANCHE!!!
Is there a method of blocking the text "donotreply" in email addresses via validation?
In my page i have two combobox. one for year and one for week numbers.Now my prob is
1.when i select a year from combo box 1, second combox box will display the number of weeks in that year.eg if i select 2005 it display me list from 1 to 53 as there are 53 weeks in 2005.
2.when i select a weeknumber from combobox 2 and press submit button it ll display start date and end date of entered week.
This query sort on the basis of Lft and Rgt columns.
The name of the array is: aEmp.
My question here is how can I get only the LastName from the aEmp array into another array so that I can sort the names alphabetically and then display the employees in the alphabetical order.
Or is there is another way I could this by using the same array while keeping the lft and rgt sort of the query? If I sort based at the SQL query level, I can see the names sorted by the lft, rgt and lastname, but since the lastname is at the end of the sort list - it does not appear alphabetically.
In working with arrays, I have found that I am unable to dimension and array with a variable that has an integer value but I can redimension one this way. I haven't see any information that tells me if this is a requirement, although it appears to be because I get an error if I try it.
Ex.
Dim b b = 10 Dim a(b) ' this errors out but Dim a() ' this Redim a(b) ' works
I want to call a recordset so you can edit the details and then obviously pass the parameters onwards into the db. However, the user guide just says this:
To process other fields in the form, use the Form collection of the upload object the same way you would use the Form collection of the Request object. For example, if your form had a text element named UserName, your processing code would include: Code:
