i am auto numbering with sql in asp. my auto code worked but i am restructing my tables and i came across my auto numbered fields. my question is when you use auto number does it give an default field length in mssql and if it dose how do you specifi how long you want the field to be.
here is a sinpit of my code for a table using auto numbering.
sqlStr = "CREATE TABLE Consumer(Con_id INT IDENTITY (1,1) NOT NULL PRIMARY KEY, "&_
"Con_Fname VarChar(25), "&_
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.
Say I had a query which listed the below, from the database:
Fiesta
Citron
Metro
Skoda
Mondeo
How could I write something so that however many results are returned it automatically numbers them like this:
1 Fiesta
2 Citron
3 Metro
4 Skoda
5 Mondeo
So that no matter how many results came out it would just keep on numbering...?
i need some one to help me how to do numbering with asp. for example if i want to display 10 titles in a page and the others shown on the next pages.i.e 1.2.3.4.5 etc.
thanks for quick response.
When you pull out some certain data from the DB, this is generally how it looks like in a table...
jill 123
jeff 444
alex 611
steve 244
But my question is that, how do you LIST the data beside them? its nothing to do with the table ID, its just when you pull the data out of the DB, you could use the ASP function ( I do believe there has to be one?) to number the data? This is how I mean...
1. jill 123
2. jeff 444
3. alex 611
4. steve 244
I am trying to add in another column on the left of this table to retun a sequential counts as to how many records I have returned. Such as
1 Mike
2 Steve
3 Susan
4 Sarah
5 Emily
But I can't figure out how to do it. Code:
I have two little programs, one which writes the name of a file into a log file when it is accessed by a visitor and the other to read the log file at any stage in its building. At either step, it would be useful to increment each line and see the number.
It would probably be easiest when reading the log file. I'm using: Set Txt = Sys.OpenTextFile( myCounterFile, 1 ) and then:
mytext=replace(Txt.ReadAll,vbcrlf,"<br>"). I'm guessing an incremented number goes in between but haven't been able to figure out the syntax or the modification. Also not sure if that "vbcrlf,"<br>" isn't redundant.
i have a page with top frame (html) and bottom frame (asp)the top frame come with choices and then submit value to bottom asp page by submit button.how can i do it if i wish the bottom asp to run automatically in specific value when the html is loaded.then the user can change the choices after.
View Replies View RelatedIs it possible in ASP to have an Auto Fill option? For instance, if I am typing in a name and I type in the first few characters, can ASP recognize a similar name in the database and begin filling in the rest of a possible match?
View Replies View Relatedive got an online system which allows people to enter info into a database about an absence request they have - at the same time this emails the person in charge of absences.
The form is setup now but to make it easier i want to alter the "Name" and "email" fields so they require no filling in ie - a staff members name will be chosen from a drop down list (ive done this bit fine) and then once this is done the relevant email for this person is automatically placed in the email field. This bit i am struggling with - anyone any ideas how this can be done??
does anyone in here got an idea on how to automatically send an email message once a person signs up for a website? i'm doing a small website right now and if a person signs up on the website details about the non profit organization would be send automatically to their email.
View Replies View RelatedIn my form I placed a text box, in which I want when the users writing something some choices from a database table to be presentes for example:
if they wrote
G
a drop down list to be showned which contains.
I am running 2000 server, sp4, IIS 5
I need to be able to autoexecute an asp page from a batch file that is placed in the windows scheduler.
I can execute the page fine, but I can't get past the authentication. How do I pass the username and password to windows via the URL automatically so this can be done without any user action? This is not a https but it uses integrated windows authentication.
I work for a large company and the outside supervisors are not that computer savy. The simpler the better. Each supervisor has 15 employees that he must assign work for each day(Monday through Friday and sometimes Saturday).
I am trying to create this so they can click on a button it will add 15 new records to Table A that are copied from the day before. Then they just have to update the new records with today's LocDate and a new location if needed. Code:
I have a an url to file in one page and when user clicks, it takees them to another page, say url.asp?ID=...
On this page i want the download to that file to start automatically. the purpose of this page is to record the number of file downloads. is this possible in asp, or is there a better way of doing this?
how to make a window explorer closed tiself like after 1 min? I think I rem there is such function available but I had forgotten the function/code...
View Replies View RelatedI would like to write an ASP script which will auto-login me to a Yahoo account or some user account which needs a username and a password. How can I make this possible using ASP?Or is there any way to get auto-login working?
View Replies View RelatedHow can you get cursor to "jump" from the first field that has focus onto the following one and so on, and is it possible to do so if fields sometimes might be empty and if so how would I take care of that?And is it possible to make autotabbing if the field is not a set lenght, I have only come accross examples where the field is expecting to receive a certain number of characters?!!!
Can you use the option of auto tabbing only for input field or it can be done for select options as well?
I am currently developing a web form for the transfer of assets between departments, which will store information in an Access database. I currently have the form created and I am working getting the transaction processing portion of it going.
Basically, there is a minimal amount of information that needs to be entered into the form and I would like the rest of the information to auto-fill. So for instance, I would enter the asset number of the asset to be transferred, and said asset's serial number and description would fill in automatically. I have go this working in Access, but I'm at a loss for how to do it with ASP.
I think that I need the script to execute after a change is made to the AssetNo field, but I have not been able to get it to work how I want. Code:
I am in the beginning phase of a project that will require automatic email reminders to be sent out. Has anyone had any experience or suggestions that might help me get started in the right direct. My project will use the following.
ASP/VBScript/SQL Server Express
Once a record has been added the Auto Email reminders will be sent every 24 hours for the first 3 days or until the receiving party has responded to a questionnaire.
i want to call another asp page from my aspx web page in the form load of aspx page and populate certain values in the aspx page based on the results returned from asp page.. I have to pass certain parameters like username and password to the asp page and the asp page should be submitted automatically . How to implement the form submission of asp page automatically from the aspx page. Based on the seach results, certain fields in the aspx page should be populated.
View Replies View Relatedwe have an Access database of our clients. It has fields for email addresses and date of expiry of their rents. I would like to write an application that would email our clients automatically according to the dates in the database fields, giving notice that their rent is about to expire like for example, within one month.
I just would like to ask if you could somehow give me some idea or point me to a website that will give me insights. Thanks very much indeed and hoping for your kind response.
I have no background knowledge in this area as yet.In ASP, is there a way to have a set of code to automatically redirect to another page in a given time period? eg: auto redirect to another page in 10 seconds.OR does it has to be done using javascripts or any other scripts?
View Replies View RelatedI have a form which submits it's data to a hidden page(submit.asp).Submit.asp retrieves the data and submits to the db.Immediately once it has submitted data,it will then retrieve the auto generated id for the data just submitted.(hope this will work)
Once I have retrievd the auto gen id, I want to then pass this id to *another page*. I don't want to then create the table on the submit.asp page as there is a huge amount of code there already-want to keep things clean.
How do I pass the value to another asp page?Is it something like response.redirect and how do I attach the id?
On my website I have users create an account. After they have created the account they have to log in. Is there a way that after the user has created the account it automatically logs them in?
View Replies View RelatedI want to refresh a page every 5 mins without the users' intervention.I'm not sure that this is possible at all.
View Replies View RelatedCan I make the screen state where it is after a control is auto postback? And how?
View Replies View RelatedJust a quick question, is it possible to automatically upload files to an FTP account via ASP? Ie if you have a link say, on an ASP page, saying Upload files now... and basically this would automatically upload a set of files which will be pre-set in the code... to an FTP account for which we know the address, username, password?
View Replies View RelatedI have a few .asp pages in a framed website. I find that sometimes the .asp page reads from my cache instead of refreshing the Database fields when flipping between pages using a naviagation bar in a different frame. Anyone know a little line of code that I could place at the top of my pages that will maybe automatically refresh the page ONCE - when someone enters the page ?
View Replies View RelatedI have created a form with asp, and I want to enable the autosuggest in my text boxes using a MS SQL database as a source for the suggestions. So do you have anything in mind to suggest me to use?
View Replies View RelatedHere is want I want to do. Create an asp script that can:
1.) go to a page
2.) fill in the values needed in a form
3.) click a submit button
4.) use XMLHTTP to capture the contents of the resulting page after it loads
Is this possible, and can anyone point me in the right direction?
I once found a script that would automatically notice changes on your site, and then auto-matically send a newsletter to your users notifying them of the changes, and giving a short description. I know how to do everything but get the changes and summarizing them. Anyone know of such a script (that's free)?
View Replies View RelatedHow to create auto responder in ASP.
View Replies View Related