I have a web page that submits a form to a database. Each time a form is submitted, I need to assign it a unique case number and insert the case number into the database along with the information entered in the form.
I am able to insert all the data into the database, but am not sure how to generate the case number to insert. Is there a way to do this based on number from the previous entry, like just add 1 to it?
I have this simple application that I put together using ASP. It has an html form that submits to an access database through a simple ASP file. It’s a survey form basically. One of the departments here wants to get some feedback from their students and in return for filling out the survey they will be entered into a drawing for a gift certificate. The catch is that the survey is anonymous. What they want to happen is each person is given a unique number at the end of the survey and they will pick one of those numbers randomly to see who the winner is. How can I possibly do this? I am stuck.
I think I may know what I need to do:
Pull a unique number from a database and post it onto the HTML form near the submit button. Notate on the page that the user write the number down and when they hit submit it is inserted into the database along with the record. I have absolutely no idea how to do that.
The HTML form submits into the database using this "add.asp" file:
Code: ....
How can I generate a unique random number?
View Replies View RelatedI'm having a bit of a problem and I was hoping someone could help me out. I'm trying to create an interface for manipulating historical stock prices obtained through finance.yahoo.com. I need to make a recordset contain the data of a CSV file that Yahoo returns, but the catch is that I want to pass the data along by pointing the recordset to the URL of the CSV files on the Yahoo server.
Yahoo creates its CSV files dynamically through the querystring of its URL (see below), and I would use inputs to my interface to manipulate the URL for specific ticker symbols, dates, etc. I guess the simplest example is that a user could input a ticker to my interface, the recordset would somehow "call" the URL for the correct data, and then that data would be in the recordset, where I could manipulate it, before returning the information back to the user.
I'm just stumped on how to get the CSV data into the recordset on the fly, just by calling the URL.
The following link is an example of what Yahoo does. Manipulating the querystring changes the ticker, date range, and level of detail. You can also change the table.csv to table.txt and return the actual data in one big text file. Code:
After data has been put into a table, how do I then get it to return the unique ID assigned to that record?
View Replies View RelatedI know that MS have limited the form data size which about 100k however, I need submit a data that may be less or more than 100k, such as 500k.
I have found a code that using x-www-form-urlencoded
read the form data as binary code
than using ADODB.stream to convert back to string and display it out
but, that solution cannot handle chinese word, any idea on it?
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 Relateditemname = "select sw_item_itemid, sw_item_item , sw_item_lowquantity"
itemname = itemname & " from sw_item"
itemname = itemname & " where sw_itemcategory_catid = "&catid&""
set displayitem = objconn.execute(itemname)
if displayitem.bof and displayitem.eof then
counting = counting + 1
("countnotitem" & counting ) = filtercategory("sw_cat_catlabel")
how can I assign countnoitem with a digit ?
I got a session variable for username. Now, i want to assign this value to the textbox.
HOW WOULD I ACHIEVE THIS?
I put in a request recently for a script which would return 9 random numbers between 1 and 30. I got a reply which gave me this script, which writes them out.
It works great, but in the loop that writes them out, instead I would like to assign each value to a variable, such as img1,img2,img3,img4, etc. in the for loop, is this possible, or should I write out 9 statement lines, each assigning a value to a variable. I intend to plug the values into a java applet which rotates images.
Come to think of it, I could just put each value of the array right into the img tag, no? <img src="images/<%=random_number(1)=>.jpg"> Code:
I have a code somewhat like this:
Dim screenSize
If Request.Form("resScreen") = "1024x768" Then
screenSize = "big"
Else
screenSize = "small"
End If
this works fine, but when this page is reloaded, it doesn't
find this Request.Form("resScreen")
(this form is also on another page, which explains why) but can I store this variable "big" the first time it loads somehow?
For Each objitem in Request.Form
if request.form(objitem).count > 0 then
For intLoop = 1 to Request.Form(objitem).count
Objitem = request.form(objitem)
End if
Next
server error in line of "end if"
I want to collect the values from the form and assign a variable to each value field
I am using Visual Studio I have created a website using HTML code and the pages look fine I now need to do the following.
I have a picture where if some one clicks on it it then needs to query an SQL database and return on a different page the results. How do I assign a sql database to my website and how do I connect to it ?
I would like to ask izzit correct that assign a variable in asp and store the value select from XSL list at below: (in my asp page) Code:
View Replies View RelatedI'm retrieving the screen resoltion with javascript code, but i can't assign the correct value to asp. the response.write is displaying zero (0) for screen res., although when i do a document.write in the javascript part, then my screen res. is 1004 ...
View Replies View RelatedIf I assign VBScript server side variable a to javascript variable x, it is fine.
<%
Dim a, b
a = 10
%>
var x = <%= a %>;
alert(x);
But if I do the other way around, then it has 500 error. any ideas??
<% b %> = x;
My ASP page contains the following VBScript code:
<%
zipCode = Request.Form("zip")
%> <br>zip: <%= zipCode %>, rf: <%= Request.Form("zip") %>
When I enter "abc" into the "zip" field on the form, I get the
following output:
zip: , rf: abc
Why doesn't the first statement assign the "abc" string to the
variable "zipCode"? What am I not seeing?
I'm setting the title attribute of an input box to assign a tooltip. If I assign title the value "Agent does not exist", when hovering over the textbox the tooltip will only display "Agent" it's the same with all my tooltips (only the first word is displayed).
View Replies View RelatedHow can one 'assign' value of a session variable to a variable, something
like: temp = session("variable").
URLURLOn page load there is a variable called "id" it has already got the value (say 7170)
I have a query in a function that executes a dataset, the query is "select Col1, Col2 from persons where id = " & id
Therefore, on page load - how do I call the function. Assign the value of Col1 to textbox1 and the value of Col2 to textbox2.
In the text box I would use <%=var %>
But how do I assign the result of the query to the variable?
Would it be worth using a datareader instead?
Before there was XML my world was in order, I would once a year write some small ASP script, it would perhaps take me all weekend, but it was doable, now the devil has entered my life, in form of an XML file ... Code:
View Replies View RelatedI am trying to update an integer field in an Access database with a null value (ie, make the field empty). It currently has an integer in it. Here's the code I've tried, which normally works for all other updates:
set rs = Server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = sConnString
rs.Source = "SELECT * FROM tblFixtures WHERE FixtureID = " & strFixtureIDcurrent
rs.CursorType = 0
rs.CursorLocation = 2
rs.LockType = 3
rs.Open()
rs_numRows = 0
rs("ArticleID") = ""
rs("Result") = ""
rs.update
rs.close
set rs = nothing
However I am getting a Type Mismatch error on the rs("ArticleID") = "" line. Where have I gone wrong?
Is it possible to assign javascript variables values to ASP?
e.g. How would I store the following JS variable as an ASP variable in VBScript?
<script type="text/javascript">
var intJavaScriptNumber = 25;
</script>
The problem is I've got about 50 of these variables on a page, and they all need to be used in a simple equation which slows the browser down. If I could get them all into ASP then I could process this server side much more comfortably.
Currently, my repeat region is showing all of my repeated records that are being brought in from my database. I would like to display these records in a confirmation page, but I am having problems having them display in my confirmation page.
I tried to assign a hidden value to the repeat region, but I am getting no data to come across. Below is the code that I'm using: Code:
I am bringing in a repeated field from a database and I would like to assign values to radio buttons to be associated with each record. The number of repeated fields will be different for each person, so I cannot enter values for each repeated record. I need a way to assign a variable as well as a value to each record that is being brought in from the database. For instance:
Radio Button Value 3 4 5
Repeated Record 1 O O O
Repeated Record 2 O O O
Repeated Record 3 O O O
I had received some great code from Memnoch, but it created one group for the entire Repeated field, so I was only able to select one radio button for all of the repeated fields. I need to select them seperately and I then need to Request the variable so that i can add, multiply and divide that variable with other repeated variables.
I need help with some asp code that would allow me to grab the last record id and add one to it for the new record being inserted.
I am new to asp and have been banging my head up against the wall trying to get this to work. I am currently using Visual FoxPro 6 for my database.
The SQL statement I am trying to use is:
strSQL = "SELECT Max(contact_id) FROM CustomerContact;"
i'm building an ecommerce website and I want to create a unique orderID for each new order. My problem is that I don't want to have a random number but a number where each orderid is one higher then the last order like for example 4850323, 4850324, 4850325....
I tried to do this by using an application variable where 1 is added after every order but
this doesn't garantee a unique number because if IIS is reset it also resets the application variable.
I've a databse of product in which I've unique ProductCode plus a ID that increments by 1 (AutoNumber). both the code and ID are unique and there will be no duplicate but is it worth having both in the databse?
I mean, can I not just use the productCode and forget about the ID? does this makes any difference? as far as I can see I'll have no problem in using the ProductCode. how you'd do it.
I need to insert some number into database as text. My problem is if I insert the number (ie. 4.0), the value in the database only show (4). So, is it possible to convert a real number into text number using ASP?
View Replies View RelatedWhats the best way to create a Unique ID and insert it into a Access DataBase? the field that holds this is a text field, and is called company ID.
Its a text field because it seems to cause less hassle
I have a list from a database which I have made into a dropdown box, with each option as one line from the list.
At the moment I have several repeat values which I do not want.
I can set up a series of nested if statements and loops to remove the duplicate values but I would expect there to be a function which does this much more easily.My question is:
Is there an easy way of only displaying unique values from a database using ASP and SQL.
This is about a simple form validation in asp using javascript.there is one field called invoice_number which requires an unique invoice number as input. Whenever user inputs duplicate values message should pop up as warning on submit of the form. A sql fetches all the invoice nos. from database into an array using getrows.how do i use the result of getrows in javascript to perform client side validation
View Replies View RelatedI am trying to find a best algorithm to generate unque id(alphanumeric less than 10 character long - not GUID) for entering orders in orders table for an e-commerce site.
View Replies View Related