Auto Number Retrieving
how to retrieve the auto-number value from the table. This value will be displayed in the textbox.
View Replies
ADVERTISEMENT
Retrieving Auto Generated Key From DB
I have an insert query that creates a customer record, this record is given a ReferenceNo that is autoincremented within Access.
What I want to know is how can I retrieve this value after I have applied this update. Using MySQL I know there was a way to retrieve autogenereated keys, but is there something similar that I can do via the ADO stuff and access?
Retrieving A Ticket Number
I am able to connect to sql databae and it's retrieving all the tickets. Is there a way to set a query string to display the current ticket number that was generated in the database. Here's the code
str="SELECT Ticket_Number FROM Escalation_Forms"
rs.open str
While not rs.EOF
Response.Write rs("Ticket_Number") & "<BR>"
rs.MoveNext
Auto Generate Number
I want a sample code for developing an " auto genearte number " and want to store in database.
View Replies View RelatedAuto Number Generator
i am developing an e-move system. basically, this system required a customer to login first into the system before make any reservation. when a customer complete fill up a form with required data such as name, address, telephone number, email, date and time, i was wondering to give the customer a specific number as a reference number. customer will use this number to retrieve back the information if he has any changes to make and also to view the propose quotation from the mover company. my problem is, how can i include that particular process (reference number) into my e-move system?is there any auto number generator code/application?
View Replies View RelatedAuto Number Field
I have one auto number problem in one table in sql server 2000. I'm inserting new record using insert statement and am not giving any value for that field as its auto number.
On the very next statement , I need to know which number it inserted in auto number field for that record??What should be the logic?
Pulling Auto-number
Is there a way to pull the auto-number of a row entered into a database? IE, if I create an order, automatically pull the order_no from the order_table so that I can insert it into an order_detail table. There has to be a better way then selecting max order_id because that might not be the most current order? I know there is a buiilt in function in php what about asp?
View Replies View RelatedDisplaying Auto Number Prefix In ASP
I'm developing a help desk system and i need to specify an ID for each call.
Using autonumber in Access i formated it ("NS"0000) to display NS0001 but
my ASP page only shows 01 when i display it.
Auto Numbering (letter-number)
i want to make a data field with an auto numbering , but i exactly want is like this CT-1 , CT-2,CT-3 , the Ct letters must be before the autonumber , so its seems to me in that case i cant choose the dat field in my db as int and choose identity Yes cause the identity seed will be an integer only and no way to put with it a number.
so i want to make throw asp and put this datfield as a char so it can accept the(letter-number)value , so how can the asp make an autonumbering, and know what the lastnumber so it can add 1 to it.
Auto Number Field Error
sqlstr ="INSERT INTO BorrowerTab VALUES('" & strName & "','" & strEmail & "','" & strPhone & "')"
These are the 3 fields i wish to insert value.
I cannot do it because there is an auto-number field in my table.
How do i tackle this ?
The error tht i get is query or destination are not the same
Auto Serial Number In Multiuser Web-based Application
I am developing a web based application that has autonumber field for the serial number. Every time the user open the page a serial number will be generated. The problem is when more than 1 user open the page at the same time or before the first user submit the form they will get the same serial number.
How do i make sure the second user will get a different serial number?. This application seems to work as standalone only. How do I change it to multi-user environment.
Convert Real Number Into Text Number
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 RelatedSequential Number After Batch Number
here is the scenerio
in master batch table i have various master batch like
200701-0001
200701-0002
200701-0003
Now each master batch can have multiple final mixed batch like
200701-0001-01
200701-0001-02
200701-0001-03
and this record is inserted in to fmix table.
so i have a form in which i have a dropdown menu in which all the master batch is listed,
i select 200701-0001 and that value is passed to next page where i will enter other fields data and insertion to my fmix_no will be done automatic like 200701-0001-01, 200701-0001-02 and so on,
how to achieve this
so in short each master batch will have more than one final mixed batch.
pls help, also if u have any online contact in yahoo or msn pls send me, i am so confused and badly struck deadline is just couple of hours away. my yahoo id is(E-Mail address blocked: See forum rules) you can PM me i am online right now.
Retrieve The Error Number In VB With Err.Number
I want To handel the error messages by myself in one part in my script. I know that in VB I can Use the statment - On error resume next And I also know that I can retrive the Error Number In VB with Err.Number.
How can I handel the errors by myself in ASP? I heard about the ASPErr Object, Is it the same thing like the err object in VB?
Retrieving
When a new record is inserted into access db it creates an id, how can I return this value for a record I have just created?
View Replies View RelatedRetrieving Value
I have the following code in my form:
Response.Write("<form name='Testing'>");
Response.Write("<INPUT type=hidden id='Testing_txtbox'
name='Testing_txtbox' value='a simple test'>");
Response.Write("</form>");
If I type the following in the very next line, I get a value of
"undefined".
Response.Write("value="+Request.Form("Testing_txtbox"));
why this won't work. and how I can retrieve values of hidden controls via Server side code?
Retrieving XML DTD Doc
I have a DTD xml doc and need to read the data from it and display it using ASP.
View Replies View RelatedRetrieving Name Tag From URL
I want to know if there is a way to retrieve the tag from the URL, I don't know if thats its name, so I'll just explain what it is:
showmsg.asp?FID=mn&ID=2467#2529
the tag, as I call it is what follows the # sign, the number 2529, in this case. so, is there a way I can retrieve the tag with ASP, by the request object, or any other way, any Ideas? Another thing I wanted to know, not related to this subject, is how do I change value of a textarea that is placed in another window with VBscript or JAVA. is it possible?
Retrieving Qty
I have three different tables I will be pulling stuff from: user_info, img_inv, activitylog:
user_info I will be using their ID and state
img_inv I will be using part number
activitylog I will be using part number and date
I'm trying to select the part number from the activities list and match it with the img_inv to make sure it still exist. If it exist I want it to do a total count of how many times it has been looked at by 7 states within a given quarter. Code:
Retrieving Cookie Value
I want to retrieve the value of a cookie to make a form a little more user friendly (our intranet is configured to set a cookie for User First Name, Last Name and Email when they log in)
Unfortunately I can't figure out how to retrieve the value of the cookie. I've been trying:
<%
Response.write Request.Cookies(UserLName)
%>
But it gives me an error - I used Checky to make sure the cookies are there and they do exist:
Name:mascot
Value: UserLName=Tarby
Can someone give me some advice?
Retrieving Values
i want some help in how to retrieve values from multiple selection listbox. i want the values retrived to be used in the search which i perform from the database. i m doing a search feature which u all often see in job search sites. so someone selects multiple cities to search in i want that to include that in my search query.
View Replies View RelatedRetrieving Url Properties
Is there a way in asp to retrieve part of the URL and use it
say the url was
http://localhost/site/craig
is there anyway of retrieving the word craig so to use it in the page
This is because i could have other addresses that are for example
http://localhost/site/Jon
where i need to retrieve the word jon
Retrieving Values
I have a form that send values to a second page. i m trying to compare the values received from the form with other values retrieved from a database. so if a value already exists then an error message is displayed. in order to compare the values i need to print them on the second page but I m bit stuck with this. i used request.form("category") in order to retrieve the values from the form but it doesn t work.
Retrieving Time
I am trying to get a field populated in an oracle database with a time stamp of when a form is submitted.
I have found out that there is a table in Oracle called DUAL which holds the current date and time. At present i can populate the date when the form is submitted using objrs('sub_date')=date() but when i query the database the time element of the field sub_date, the time displayed is 00:00 which is the default time.
So can anyone give me any help in how i can capture the time. I know about select to_char(sub_date,'DD-MON-YYYY HH24:MI') which will bring up the time but i can seem to populate the field sub_date with the time.
Retrieving Page Name
I am trying to retrieve the page name. I know this is possible using Server Variable PATH_INFO. The problem I am having though is that when I get to a page in one of my subdirectories the subdirectory name is displayed.
Example: my page index.asp is in the the admin directory so the PATH_INFO displays as /admin/index.asp. How can I strip the page name out so I get index.asp. I cannot use the function Right() since the page name could be any length.
Retrieving Properties
How to retrieve "Last modified" & "FileName" from all files in a specific folder (called MyDocs) and display on the ASP page?
eg. (in MyDocs folder)
- MikesWork.doc
- MyResume.xls
- HouseExpenses.xls
Situation
Let's assume that i just modified MyResume.xls file and save it today(10/30/2003) on my computer, then i upload it into the internet. On my asp page, i want to show all files Filename (Last Modified) in MyDocs folder.
eg.
Your Documents
1. MikesWork.doc (last modified 10/24/2003)
2. MyResume.xls (last modified 10/30/2003)
3. HouseExpenses.xls (last modified 9/15/2003)
I know it has to do with fso or something close to it... but totally have no idea (zero) of its logic or how it works. Please help me by giving me with full example.
Storing And Retrieving UTF-8
I'm writing a vbscript application that reads UTF-8 XML containing Chinese
characters and stores the data in MySql 4.0.x.
Does anybody have any experience in this area with regarding codepage and
character sets? Ideally I want the scripts to be able to handle Standard
European characters and Chinese characters as well.
Are there any special considerations for using MySql/ODBC and ADO to get and
put the data.
Retrieving Files
Right I have my files going into the database, and once successfully uploaded, a user is shown a few bits of information in a table such as the primary key, name of file, its size and the content type.Now i want to create <a href> links on the homepage etc so that browsers/users can download these files one at a time. So when they click the link, the Save.Open or Cancel dialog box appears. Have been trying different things for few days now but finally thought I better ask for some help as Im gettin nowhere.
View Replies View RelatedRetrieving A Zip File From A Url Using Asp
I have a zipfile that is created dynamically for me on a webserver. I have the url of the zip sent as a post value to an asp script on my website.
In my asp script I need to be able to retrieve the zip file so that i may extract content from it using an asp zip component. Any idea how to retrieve the file?
Retrieving 200 Characters
I have a SQL statement to retreive results based on keywords entered
I only want to show the first 200 characters of the field though, how would I modify this code to do just that?
SQL = SQL + " instr( 1, lcase( description ), lcase( '" + aKeywords(i) + "' ), 1 ) > 0"
I thought it would have been something like:
SQL = SQL + " (left(instr( 1, lcase( description ), lcase( '" + aKeywords(i) + "' ), 1 ), 200) > 0"
Retrieving User From Db
i have a checkout page which lists the user and what they have puchased. however, theres a problem with this page as I cant retrieve the user from both tables in my db, Customer & Corporate. The error message that I received is:
Microsoft VBScript compilation (0x800A03F4)
Expected 'If'
/shop/check_out.asp, line 412, column 3
End
--^
which refers to the red line in the code below: Code:
Retrieving Varable From ASP To ASP.
I have an .ASP page that comes up, and I am trying retrieve a variable from
the previous .ASP page. However none of the variables from the previous .ASP
page are available to the current .ASP page. There are three pages in this
chain.
1. NewUser.html
Information is input in this page, and posted to the next page using this
tag <form method="post" action="newUser_response.asp">.
2. NewUser_response.asp
Information is retrieved from the previous page using the
<%=request.form("strADLocation") %tag, and then posted to the next page
using the <form method="post" action="newUser.asp" This page is basically
just a confirmation page, and just displays the information from the
previous page, and sends it to the next page.
3. NewUser.asp
This page is supposed to retrieve all of the variables from the previous
..asp page using this syntax strADLocation = request.form("strADLocation"),
and create a user account, but none of the variables are available to the
script portion of this page from the previous .asp page
I had a similar problem when I was trying to make variables available to a
..asp page from a .html page, and later found out that I had to re-declare
the variables in the second page which was an .asp page using this syntax
strADLocation = request.form("strADLocation"). Everything worked great at
this point(HTML to .ASP). The problem I am having is that I added an
additional .ASP page(NewUser_response.asp) in the middle, and I can't seem
to retrieve the variables from the previous .asp page. Now the chain is HTML
to .ASP to .ASP. If Code:
Retrieving Dates
when i retrieving date the dates come out in american format
eg 01/28/2006
how do i get it so it come out in 31/01/2006 ?