I have a web page with three fields, Name and designation, salary. The name field is a <select> tag which contains all the names present in a tabe. When I select a name, the corresponding designation should be displayed. Then I enter salary and submit the form. There are two submts involved?
View RepliesI have a form where the first field is a dynamic drop-down that pulls from a db (Access). The fields associated with the query are task_id, task_name and task_rate. The field has the value of "task_id" and the label of "task_name".
In the second form field, I would like the default value to be determined by the selection made in the first field. Based on the selection of the first form field, I would like the default value of the this field (task_rate) to be populated with the associated task_rate value of the selection chosen above.
I am planning to build a basic page that brings up images from a Database based on keywords.
View Replies View Relatedi now have my dropdown connected to my database. everytime the user adds a new record, he simply has to choose a Department from the dropdown menu. However, when he tries to edit that record, the value that he has chosen from the dropdown and has been saved to the database cannot be retrieved in the dropdown menu.
so i want to retrieve the data from the database INTO THE DROPDOWN so it would be the default value of that dropdown menu when the user edits his specific record.
I have an sql statement like this executed with asp and mysql.
select * from table1, table2, table3
How can I read a specific field from a table when tables have same fieldnames.
So for example table1 and table2 have both a field named content.
What I would like to do is:
contenttable1 = recordset("table1.content")
contenttable2 = recordset("table2.content")
But then I get an error like item not found in recordset.
If i do this it works but i don't know which field I read from:
contenttable? = recordset("content")
I know that it works with Access but I can't get it working with MySQL.
Ive got a tool that is taking sugestions and updates from users and then generating a unique id based on the date and ID Autonumber field from an access db. I am using the addnew method b/c it is the way i know to immediately retrieve the id.. The problem is im trying to add the id back into the record on the same call. Is this possible?
My code is as follows but i seem to be getting duplicate records with unique id's.. But the thing that seems strange to me is that both records have their own unique id. If this were the case i would think that the first record would not have the unique id b/c it is not generated until after the first update call? Code:
If a sql query returns 20000 records then what is the fastest way to display records on a web page.
View Replies View RelatedIm trying to do a simple password retrieval script that displays a users password on screen.
Im being told their is a syntax error:
Syntax error
/Kosy/password.asp, line 30, column 7
.write & strEmail
Code:
Already have an asp page showing results from an access database table (supplies)
Need to know way select items from this list w/o the need of retyping to another form.
Also would like to be able to insert order_date automatically to another access table (orders).
A problem recently cropped up that I have not seen before and I am wondering anyone has seen this one?
The 2 SQl Select statements on my ASP page differ by the addition of one column ("Description") but in the 2nd case, column content is dropped (blank). I can get somewhat different results by adding other columns to the Select. Code:
I am working on asp and ms sql.
I have created a table called as 'usertable' in ms sql database. The columns in 'usertable' are username, loginid, password. The record gets added to this table, when a new user makes a fresh registration.
Eg: username = 'david'
loginid='daveuser'
password='newpass'
So My question is whenever a new user is added to a table, an automatic mail should come to me 'pra123@yahoo.com' mentioning that a new user is added to table ALONG WITH HIS USERNAME, LOGINID, PASSWORD.
All this information should come to my email account automatically. So how to write ASP Code for this.
I need to some how do the following and if anyone can help me or point me in the right direction I would appreciate it very much.
I have a form that the user would fill out. When he/she clicks submit it goes into another page that reviews the information that the user typed in the previous form. If all of the information is good for the user there's another button in that page that they would have to click.
This is what I want to happen after they click on this button. I want to record the data in a SQL database, which I know how to do that, but what I want to happen automatically right after inserting the data in the SQL database is that I want the same data to be carried over to another page where there'll be another form and want that data to be populated in this new form. How do I do that?
is it possiable in run some automatic checkups on the server every X time or every time (with no reaction with the user). I need to run all the time checkups on the sql database and check values of some column.
View Replies View RelatedI would like to backup the Remote Access database from a link on my asp application . Is it possible ?For instance, there would be a menu which once clicked will initiate login/password and ftp server, get the database and rename it with currentdate, close the connexion ?
View Replies View RelatedI want to add code to the URL so on click will be performed login action with some username and password (ex. h t t p : / / w w w . s o m e - s i t e . c o m /login&username=USER&password=PASS)
I think I wrote total nonsense, but I think you know what I am talking about
If someone want to help me here is that site I want to perform auto login: ...
if there is a way to have a page print automatically, with no dialog box when the page loads, using VBScript or Javascript. This will be an intranet application, running in IE6. I will have control over the browser settings, so those wont be a problem.
View Replies View RelatedAs u see that in yahoo messanger it provide facility for auto fill login and password for specific system. If we want to see our yahoo messanger in my personal sysem then we dont require to fill this user id and password. It automatically fills user id and password. I want to do it in asp.
View Replies View RelatedIs there any way to create automatic generation number like, INW001.......INW002.... ans so on without using any code in ms-access using "autonumber" type with default value.
or
Can you give me the code for creating automatic generation of numbers for a column IDNO , using alphanumeric.
Eg: INW001 , Next should be INW002 ,....... INW010 and so on
where I can get a script which will automatically print a page when its entered or when a form has been submitted. Ive tried to find a script to do such a fing but I really cant find anything to support it.
View Replies View RelatedIs there a way to automatically execute code in ASP? I need to send reminders for one my applications and need some suggestions . how I can send reminder emails automatically.
View Replies View RelatedI have a database that displays an editable record, with buttons for changing to different records. I was wondering if there was a way to store a template email, and have a link on the page that, when clicked, fills the records info into the email and sends it?
View Replies View RelatedI want to know if there is a possibility of mailing the iis log files automatically,say on a daily basis. The problem i am facing now is that my web host is very busy and i need to send dozens of mails to remind him. Also tell me the security previlages needed to execute the script so that i can convey the same to my web host....
And last but not the least can we develop this script with windows nt workstation + iis 4 wihout smtp.
I have created a Store front with .asp & access and I would like to setup something that emails all my users on my mailing list with a Dymanic email with the weeks specials.
But I would like it to happen automatically without any user interaction, say I would like to send it all the users @ 12.00am every monday.
How can this be done?
i want to know that how can i send automatically daily newsletter to my users.
i have started a newsletter service recently and want that everyday newsletter from database shall be sent to the users.
i also want to send newsletter on particular date in future as per selection made by the users themselves.
how can i Create daynamic pages or static pages Automatic .?
i have a problem with my website i want Create page asp classic to every member
The page name equal the member name
www.Micrsoft.com/Ashraf.asp
If i have 3000 members in my website it's possible to generate 3000 pages for everymember Automatic and if it is possible how can i do this ??
my Tec. are ASp classic and java script ..
I want to send customers and automatecly generated email once they submit a form/place order. I've been searching the net for a whille but I haven't been able to find any usefull information.
View Replies View RelatedI am having problems sending emails via the CDO.Message object from an
ASP script which was working fine. On the server I can still send
emails via the CDO.Message from a .vbs script executed on the desktop.
If I pause the SMTP service I can see mails queuing up from the .vbs
script but the ASP script no longer generates emails, nor does it error
when it creates the object.
Could this be a permissions problem? No IIS settings have changed, but
the server downloads automatic Windows updates.
Does anyone know how to setup an automatic mailer to members in a database at the end of the month?
View Replies View RelatedI'm trying to automatically submit a form to another ASP page after
some <input> fields values are filled by ASP.
I know I can do it using javascript, but is there a way to
automatically submit the form using VBscript? Code:
I need to build code to download automatically image to my local disk.
somethink like
i will specify url in code and it fetches image from that location and save
in my local disk.
for example
http://www.xyz.com/images/test.jpg
and it will store test.jpg in my local folder.
how to achieve this?
I'm trying to write a script that will send a automatic email either on loading the thanks you for ordering page. or the one before that where the order is placed pressing a order now button, it can only be send when the button is pressed and the order has been placed in the database.
Now I've writen a test script to figure out how this whole automatic emailing works but I can't get it to work. I hope someone can tell me what is wrong. Code:
My experience so far is limited to VBA in Windows based apps like Access, Excel etc.
Is ASP event driven like Visual Basic?
If so, can ASP cause the server time to be input into a field on a double click event?
my problem is i want to retrieve/get the date 3 day early using asp code, for example this date 12/10/2004 and i want to know 3 day early from that date which is 9/10/2004, do u guys have any idea....
and i more question which is how to make a page automatically run a program when the time or date is set, after the time/date has expire then a program is run, i have no idea also.