i am trying to create a html form which you can enter the course data into the form and it will add it to the database, but i want the form so when you select the course name from the dropdown box it automatically finds the id from a different table which the id is specified as an autonumber. the tables i have are courses_data with all the data in and course_title which hold the course titles and thier unique ids.
View Repliesbeen racking my brains for a while now about how to acheive this:
I have a form field where I want a user to enter their name. Unfortunately some users think its funny to enter loads of wierd symbols in their names like joe`¬;bloggs
The problem is this nearly always causes an error on the next ASP page when those wierd symbols are tried to be entered in to my database.
Could anyone tell me how I could ONLY let the user continue if they have entered alphabetic characters ONLY (no symbols)
i have a password field and i am doing validation on it i want the user to only enter characters no numbers should be entered and no invalid characters here is the code i have written for it Code:
View Replies View RelatedI 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 am new user of ASP and as well as this forum, i want to make a web page, to enter data,in which , first user login page, then he enter data on his authorize database, database names are same as user login name.
e.g if someone login as user xyz he must open xyz.mdb, and if other login as abc he must open only abc.mdb to enter data, and data entry page must validate fields such that numeric fields, text fields, numeric lenght, etc
if there is a way to use asp to automatically (i.e each time the source table is updated) take data from one table in an access database and add it to another table.
This would include getting data from multiple columns in the source table and concatenating it into one in the destination table.
I have a page shows the news from the database, normal thing. but how can we make the latest news show after 24 hours, since the shown one will remove from the page and the newer will appear.
View Replies View RelatedIs there any way to access form data in an automatic sense? For some reason, I thought you could access form elements by request.form(0) and it would give you the first form element, but that doesn't work.
My problem is that I have a dynamically generated from (to the point where fields change depending on DB data) and I need to access both the name of the form object, and the data in the object dynamically. I thought there was a way to do this, but w3schools.com doesn't have anything like that listed for the request or request.form object.
Is it possible to use ASP +/ VBScript to automatically fill in certain fields of an HTML form with data generated from what the user typed in another field?
For example, the user needs to input 24 consecutive weeks worth of forecast data. If everything is done manually, they'll have to type in a date for each of the week. I would like the form to automatically fill in the following 23 dates (each one week later than the previous field) after the user fill in the first week's date. How do I do that?
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 tried to Display data from field DB (mysql) into a Textarea to edit the text. The code I used is : Code:
<textarea name="warranty" cols="90" rows="6" class="style55" value="<%=WARRANTY%>" type="text"></textarea>
And it does not displays the data.?
I'm trying to select all the records of a Database that have the value of the "giorno" ( giorno = day in english.. i'm italian) field bigger than today.... but there's something wrong in my query. The date is in the format dd/mm/yyyy Code:
View Replies View RelatedI have an ASP variable called IRNvar:
If IRNvar(0,num) = "True" then
IRNvar(0,num) = 1
else
IRNvar(0,num) = 0
end if
In my sql database I have a True/False field called VariantFlag which is a bit data type. The IRNvar value is numeric. I am trying to insert the 1 or 0 into the database so that the field shows true or false accordingly but I get a 'Type Mismatch' error. Here's the insert statement:
SQL = "INSERT INTO Documents (CNID, DocumentPrefix, DocCategory, DocumentName, VariantFlag, PartNo, PartDesc, NewIssue, StatusID) VALUES ('" & CNID & "', '" & IRNprefix & "', '" & IRNcat & "', '" & IRNnumber & "', " & IRNvar & ", '" & PartNum & "', '" & IRNDesc(0,num) & "', 'A', '5')"
Is there a way to convert the number to the right data type? Am I doing something wrong? I'm quite new to all this so it's probably something silly.
I am designing a shopping site, in the picture the #1 section is a check box behind product name that customer can select that product to buy in #2 section the customer can set quantity of the selected product ok now codes this is the code which I have used to pull out produts and categoris from database and show them on the page Code:
View Replies View RelatedI have a page that adds data to an Access DB. When an employee adds a record I want to compare the phone number from the data they inputted to all of the phone numbers that are currently in the database for that field.
If the new phone number currently matches any record in the DB I want to have an alert that notifies the employee that a record with that phone number exists with the date that the first record was inputted and ask whether they want to continue and add the the new record or cancel the addition of the new record. Otherwise, I want the data to just be added. At this point I have a Case statement that will add the record after a submit button click.
I currently have a web page that pulls in job vacancies from a search form all written in asp and the database is in access. I will be placing an extra field which will say "apply now" and on selecting this you will be taken to a new page where you can fill in your details and email them to the employer.
My problem is I need to know how to get a field in the form that will automatically fill in the title of the vacancy being applied for from the database.
I'm trying to pass a hidden parameter from a form and when the data contains a (') or ("), it bombs. How can I remove the quotes if they exist in the data before passing the parameter?
View Replies View RelatedI use dreamweaver and i have a combobox named country and a text field named email. I want the user choose a country from the combobox and the email for this country go to a text field. Lets say the user choose England from the combobox and an email will be puted in text box. I use PHP or ASP. This is my form:
<td><select name="country" id="country">
<option>1</option>
<option>2</option> </select>
<input name="email" type="text" id="email" value="email for the country in combo box"> </td>
I have a hyper link field in access 2003. when I present the information in my form(after retrieving it from a recordset) the link appears like this:
c#http://c#
even though the actual field in the database contains only the letter "c". this is the same for every value I insert in the field..
What i am trying to do is Update data in a table with data in another table but i want to update 2 fields in the destination table with data from 1 field in another table.
These are the table i have and their fields:
*CUPFirstRound* - Table1
GameId
GameDate
Home
Away
HomeScore
AwayScore
Winner
There are 8 rows in this table, thereofre the GameID's go from 1 to 8 Code:
i have field company_name and what im trying to do is
A
Abrahams Company Alexs company AZ''x Company
Adams company Adrians Company
B
Bills company
Bobs Compay
I want the names spread over 3 columns and by alphebet category. can yous ee by the example what i mean? and is this easy to achieve?
I have an asp page that shows dynamic data from the db, I only want to show
the first 3 letters / digits from the db on the ASP page.
I get a "data type mismatch error". I assume it is because this is a number, but I don't know what to change.
<%
dim cnStr
dim rcSet
dim frmSSN
dim sqlStr
'store form input into variables
frmSSN = Request.Form("SSN")
'create connection and recordset objects
Set cnStr = Server.CreateObject("ADODB.Connection")
Set rcSet = Server.CreateObject("ADODB.Recordset")
' defining database connection (connectionstring2.inc)
cnStr.ConnectionString = path
cnStr.Provider = provider
cnStr.open
%>
<%
SQL_query = "SELECT * FROM Orders WHERE Driver = '" & frmSSN & "'"
Set RS = cnStr.Execute(SQL_query)
WHILE NOT RS.EOF
%>
I need a way of putting say 10 to 20 bullet points in one table field in an
Access database
- say seperate them with a special character, then build a bulletted list on
my page.
If I can get the page to detect each special character, insert a new bullet
and move on to the next occurance in the string... Code:
Is there away to write data from a database field into a text file on the server.
The data would be more than one line.....
I have an asp page that displays informaton from an Access database. I want to create a form that allows users to display only data that matches their search criteria.
I have made many forms like this in Front Page with the Database results wizard, but I want to manually code it. Code:
I have one field char type data length 1.. It has data either 1 or 2 in all the field tht I have checked through enterprise manager.
I'm running query:
"select * from table" and fetching all the records and displaying...
It display all the data except data from this field..Doesnt display anything..
I had put Response.write rs("fieldname")
What could be the problem?
Has anyone else found a memory leak using ADO streams to access binary data held in a database. I have searched through this forum and have not come across anyone else, so maybe it is just me.
The scenario is as follows:
Windows 2000 SP3
MDAC 2.7 SP1
IIS5
MySQL 3.23
MyODBC 2.50
If I query the database and do a response.binarywrite everything works fine and no memory leak. eg. response.binarywrite myrecordset("blobfield")
If I read the very same BLOB field into a ADOstream I then get a memory leak in DLLHOST.EXE of how big that binary field was. ie If the picture is 140k in size DLLHOST.EXE increases its memory size by 140k.
This keeps on happening until DLLHOST.EXE is something like 250 MBytes in size at which point it stops working. Quick restart of the IIS Web service and I get all my memory back.
The command I am using to get the data into the ADOstream is picturestream.write myrecordset("blobfield")
I have also tried putting the binary data into a variable first before inserting it into the stream:
set x=myrecordset("blobfield")
picturestream.write x
The stream is closed and set to nothing at the end of processing. Everything is cleanly shut down. Through testing I know the memory leak occurs once the data has been written into the stream. The stream is correctly created as type binary.
The stream problem I am encountering does not seem to be limited to ASP, I tried it using Visual Basic to create a COM component to do the same job and still got a memory leak.
So the questions are:
1. Has anyone come across this before or fixed it?
2. Is there another way of getting binary data out of MySQL, something like the opposite of LoadFile?
I have wasted so much time on this problem but cannot find, having searched Microsoft's knowledge base and the rest of the web, any reference to the problem.
For some reason the office manager wants to press enter for go to next line not tab - how can I do this without the form submitting?
I have tried to point out tabbing is not a issue to anyone in the office but she is being stubben.
I have a text field in a web page I am working on that seems to be calculating phone numbers before inserting them into an Access database. i.e., 867-5309 will result as -4442 in the Access text field. My guess is that the webserver or client is processing it before inserting it. Is there any way to stop this other than using a validation script?
View Replies View RelatedI have a form on an ASP page that shows a whole range of miscellaneous stuff. The parts in question are a single text box and a submit button. When I use the submit button, my form does what it is supposed to.
However, if I put focus on the text box and press the enter key, my form submits to the next page, but it's blank. Any ideas.
I am trying to dissable the enter key on a form. Users are hitting enter instead of tab and results in an error. Can I dissable the enter key or make the enter key function as a tab?
View Replies View RelatedWhen the cursor is in an INPUT TEXT control and the Enter key is hit,
what it's happen. I mean what is the chain of actions starting from that
point.
I have an ASP application that save modifications (qty chang in an input
text) when the user navigate from page to page. For doing so I check if
the value of the TEXT control differ from the value in the table. If so,
I insert or update the table. But, when I hit Enter it is exactly the
same as if I moved to another page. I would like to know exactly what's
happen, in order to take advantage of this behavior.