I want to use field values outside a recordset. When is use "set speler8 = rs.fields("naam").value" I get an "Microsoft VBScript runtime error '800a01a8' Object required: '[string: "John Doe"]'. I can't find the info to resolve it anywhere. Can someone help, it's probably verry easy, but I don't know it.
I am looking for some help in writing an ASP script to check for duplicate values in a database. Using a web form to add and edit the records, the user will type/edit the data including phone number.
If the user types in a phone number or email address that is already in the database, I would like an alert box to indicate the name of the person with that phone number when the form is submitted. This is a more user friendly error instead of "Microsoft JET Database Engine error '80004005' ".
I have a form F1, once submitted it goes into another form F2, I want the fields in F2 to be filled with the values the user filled out in F1. in php I would use the $_POST[] to get it, but I dont know nothing of asp
and from what I could find on the web, would this work?
and what if they accessed the page directly, rather than through a previous form, would it field appear blank? or do I have to have an if statement. also what if based on the F1 value I want to select (check) a checkbox/radiobutton or drop down menu in F2?
I have a check box and I need to automatically select certain values from the avaialable selection in drop down lists when the tick box is selected. So check box is selected and then drop1 = blah1 and drop2= blah2.
Would somebody have an example i can work on a bit, I am not sure if JavaScript is the best way of handling this, not very good with making anything work automatically.
I loop through a recordset to return values that populate a form which the user can then edit and save. However these fields need to be validated first to make sure the data entered is correct. I have a Firstname field that returns 3 records from my recordset which means when I try to validate, I get an error as the page doesn't know which of the 3 to use. I believe I have to do it through an array, but have no clue how as my efforts have failed
I have a request form that is used for requesting copies og an edition of a magazine. What I need to do is get back the information, from a MS Access table, for the issuedate and deadline.
Because the deadline is not always the same number of days (ie dependant on issue it could be 14 days before, or 21 days before etc), so as well as picking the issue date from the table, I need to be able to get the deadline date back, and write to a seperate Request "field" on the Form. Code:
I'm having problems retrieving all the values from a multiple selection field using the freeaspupload component.
I'm creating an online email app that uses the freeaspupload to add attachement functionality, which means the form encoding type is multipart/form-data. I've done something similar with the persits aspupload component, and had no problems with that, but the freeaspupload version seems to handle <select> fields slightly differently. Code:
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:
I am using a Relational database for my site and i have the following tables:
FIXTURES, GAMEDATES
the fields in FIXTURES are:
GameDate Home Away
(All of the above are numerical fields)
the fields in GAMEDATES are:
DateID(integer) GameDate(#Date Field#)
What i have done is in the GAMEDATE field in the FIXTURES table i have used the ID number of the date that i wish to assign to that record - using a LEFT JOIN to display the actual date that is pulled from the GAMEDATES table (That which corresponds to the relevant id used in Fixtures)
The problem is that in some of my code i want to display records using sql and sometimes in the where clause i use the following:
WHERE Fixtures.GameDate<=(Date())
obviously meaning WHERE GAMEDATE is LESS THAN or EQUAL to TODAY.
The thing is when i use the join it does not use the where clause and displays all of the records in the FIXTURES table.
Does any one know how to get around this, i have not received any error messages it just isnt displaying the right data
Im comparing values in a field while doing a loop if sAct<>myData(5,i) then At the end of the loop I make the value of sAct equal the current myData
This will work when comparing other fields withing my recordset (so I know the statement works) but it will not work for the field I want to compare. The only difference with this field is that it has null values. Could this be the problem? if so, how do I deal with nulls?
I have a input form with 5 fields. One of the fields is MajorNo and the other is named Description.
I have a reference table in my MS Access database (tblMajor)that lists the major numbers and their descriptions.
I would like to have the description field in my ASP automatically filled based on the major number entered on the form, so the user will only need to input the major number when submitting to the Access table (tblSalesTotal).
I am trying to pass a hidden field value on a form into another field on the form so that it can then be inserted in the database, to enable me then to reference that number at a later date.
(The hidden value (1 for example) would then automatically get passed to the other input field.)
The code for the text field that allows users to type an number into it for submission to the db is below, but what code do i need within the hidden field to populate this text field below so that users do not have to type the number in? Code:
I have being working with making an edit field over the past few days. The edit function is now working fine. The edit fields that i have are for id, subject, notes, timedate.
All of the edit screens are one line text screens. What I want to do now is increase the size of the notes box to a larger textarea type box to make it easier to edit notes. The notes field in the db is a textarea field. Code:
When you select the "Country" field in a Hotmail "get new account" link, the field "State" changes automatically, giving you the correct States that belongs to the chosen Country.
I have a main data entry form which has a link to a detailed data entry form. The value of the link in the main form is the sum total of all the line items in the detailed form. The detailed form has fields to capture the individual line items like contracted service expense, travel expense etc. I am capturing the total of individual line items using session variables so that when the values of the main form is saved these total of line item values get saved. However, if one gets to the mainform via login and tries to resave the values (which is already saved), the above session variables (from the detailed form that contains the sum of line items) get null values. However, just navigating to the detailed form through the link and coming back to the main form sets the value in the session variables.My question is how to get the session variable values without having to go to the detailed form and come back to the main
if it is possable in ASP i could store a value in one ASP page and look at it on anouther ASP page. for example:
On a login page i want that page to store a value called rights that is a number. when it goes to any of the other pages EG add user, Delete users if the user does not have the needed rights to takes it back to the main screen.
I wish to get and set values on child controls on a formview.For example. Changing the text in textbox. Hiding or unhiding child controls based on user. Replacing a blank with a default or calculated value that will need to be generated at runtime.It seems as though this should be thoroughly documented, but I'm not finding much.
i need to know if i have a loop that outputs values for each month how do i get it to add the values and only display them every 3 months,(every quarter)?
jan 123 feb 234 mar 432 first Q 789<---------how do i do this? Apr 125 may 548 jun 323 second Q So on..
I need to use the value=rs("image") in a javascript function, but i need the selected value of rs("iname") in an ASP array. Request.form("dd1") will always give me the value of rs("image"). Is there any way around this?
Using a query statement, I am trying to add values into the textbox of an ASP page to enable users to edit it. But it only displays the first word of the record. The rest of it gets chopped off. Code:
<P>Company Name:<INPUT NAME ="CompanyName" style="WIDTH: 371px; HEIGHT: 22px" size=47 Value=<%=objRec.Fields("company_name")%>></P>
The value in the textbox only shows R1 when the value in the SQL database is R1 International Pte Ltd. The datatype in SQL is char if it makes any diff.