No Record Notification
I have a page.asp?ID=xyz which redirects to releavant page and works if page exists but gives an error if not a valid page. How do I get it to redirect to an error message page being more user friendly?
View Replies
ADVERTISEMENT
Email Notification
I have a form where public can fill in information and submitted into an access database, like the following:
Set adocon = Server.CreateObject("ADODB.Connection")
adocon.Open "dbcmpda"
Set rsaddcomments = server.CreateObject("ADODB.recordset")
str = "SELECT * FROM plaint; "
rsaddcomments.cursortype = 2
rsaddcomments.locktype = 3
rsaddcomments.open str, adocon
if request.form("comment") <> "" then
rsaddcomments.addnew
rsaddcomments.fields("comment") = request.form("comment")
rsaddcomments.fields("fname") = request.form("fname")
rsaddcomments.fields("lname") = request.form("lname")
rsaddcomments.fields("add") = request.form("add")
rsaddcomments.fields("email") = request.form("email")
rsaddcomments.fields("home") = request.form("home")
rsaddcomments.fields("mobile") = request.form("mobile")
rsaddcomments.fields("date_c") = date()
rsaddcomments.fields("time_c") = time()
rsaddcomments.fields("lawenf") = request.form("law")
rsaddcomments.fields("ptype") = request.form("ptype")
rsaddcomments.fields("fee") = request.form("fee")
rsaddcomments.fields("occur") = request.form("occur")
rsaddcomments.fields("site") = request.form("site")
rsaddcomments.fields("city") = request.form("city")
rsaddcomments.fields("province") = request.form("province")
rsaddcomments.fields("stadr") = request.form("stadr")
rsaddcomments.fields("countryoc") = request.form("countryoc")
rsaddcomments.update
rsaddcomments.close
set rsaddcomments = nothing
set adocon = nothing
comm = ("Thank you for reporting piracy.")
My question is instead of putting these fields into an online database, can we send them as an e-mail in a text format delimited by semicolon and then import them into a local databse for security purposes ??? and if i can could give me an example how?
Receive Notification
Is it possible for IIS to send some sort of notification when an ASP
error occurs on a page?
I can see them in the web logs, but I was wondering if there was a way
to receive an email or some other alert
I thought about using CDO Send Mail, but this object is often what
cause the error in the first place.
Email Notification
how can i add on email notification when an ASP form is submitted.
View Replies View RelatedEmail Notification
Is it possible for one to program one's pages as such that when a database table is updated over the web, via a form, that an e-mail confirmation is sent to a specified address, notifying the update has taken place? If so is there a tutorial out there that is easy to understand and implement?
View Replies View RelatedNotification Tool
I am looking to build a desktop based notification tool which can be placed at tray bar. Well I have an asp script which checks my emails now I want to build a notification tool so that whenever I receive any new email the notification tool pop up a message at tray bar and show me that New email received.
View Replies View RelatedReceive Email Notification
I have a form (it's a .asp page) that people fill out to receive a free brochure. The form results are sent to a database (mdb).This is what I want to do. I want to be notified by email everytime someone fills out the form. I also want to be able to use an auto-responder and send an automatic message to the person that filled out the form.
In the future, I would like to be able to have the people be automatically signed up for the newsletter (with the option of not be added to the newsletter).
Yahoo/MSN Messenger Notification On Website
Is it possible to notify your website when you log in to messenger?The idea is to show on the website which site opperators are available on the messenger services for a IM question and answer session.We has a rudementary chat option as an idea but many of the site opperators are on mobile devices.
View Replies View RelatedSubmit Form Notification Message
Using ASP and/or JavaScript, how do you create that little
notification message (usually in red below the submit button) when the
Submit button is pushed. Something that says "Your information is
being sent ..."
Email Notification Query (many To Many) :: Multiple Directions
I could sure use some conceptualization and query help with a Page Watch
System I am building in Access 2000 and Asp.
I need to cycle through databae and generate a compiliation query email that
notifies a person of yacht(s) that have changed on our website:
Key database tables.....
0x80004005 Error, Cannot Add Or Change A Record Because A Related Record Is...
I'm getting this error message: Error Type:
Microsoft JET Database Engine (0x80004005)
You cannot add or change a record because a related record is required in table 'employees'. Code:
Insert Record Goto Last Record
I have an insert record form that posts fine to a db which automatically creates an ID how could I get the next page to do a preview using the ID just created by the DB to go to the right record?
View Replies View RelatedRecord Numbers Against Record Problem...
I have a .asp page which lists a date, then a bunch of record lines for data that falls within that date, then the next date and it's bunch of data record lines. e.g.
Ship Date: 04/06/04
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
What I want is:
Ship Date: 04/06/04
1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx
4: Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx
How can I get these numbers printed againsts the records ?
Record Set
I want to download record set from my SQL database as csv format but in ZIP file .I can download as a csv file now ..But i can't put that in zip file and download.
View Replies View RelatedRecord
how to deal with multiple recordsets on the same page?
It's gotta be something small and clear so I could understand.
Somewhere I've read that multiple recordsets are not allowed when using Microsoft Access Database?
Set Record
I am looking to
have some sort of SQL Trigger maybe? I have a field called 'dateActivated' and 'isActive'I'm looking to somehow say when dateActivated + 6 months then set isActive = false. I want this to
be automatic. I am using ASP/VBScript if this somehow matters.
Add More Than 1 Record At Once ?
I have a form on an asp page which is used to add additional users to
the DB, i.e. adding a UserID (PK on table), Password & Email.
The companies are allowed a max of 3 users. If the company only has
the default 1 user and wishes to add another 1 or 2, then the form
displays the current user details, not in text boxes as this is not an
adit data form. The additional user/s can be entered into 1/2 rows of
text boxes, user 2 & 3.
If they decide to add 2 new users, how do I add the additional 2
records to my db table on submit ? Code:
Record Set
i am tryin to run a search on a db and am using a like statement which works fine but i want to select what it finds and also the next 9 records any idea on how to do this
View Replies View RelatedSecond Last Record?
Is there any way to change the following code so that when it's the second last record in the set it doesn't put UNION ALL at the end? Basically, is there a way of saying:
if SecondLastRecord then
I don't know how many records there will be, so I can't count down from 7 or anything.
Code:
Add New Record From Asp To Sql
Every time I try to ADD a new record from my asp page to SQL table, I got this error:
Microsoft OLE DB Provider for SQL Server (0x80040E2F)
Violation of PRIMARY KEY constraint 'PK_Cancelled_Classes'. Cannot insert duplicate key in object 'Cancelled_Classes'
Here is the Insert statement:
Sql="INSERT INTO Cancelled_Classes (yrtr, cou_id, cancell_date, Message)" sql=sql & " VALUES " sql=sql & "('" & Request.Form("yrtr") & "'," sql=sql & "'" & Request.Form("cou_id") & "'," sql=sql & "'" & Request.Form("cancell_date") & "'," sql=sql & "'" & Request.Form("note") & "')" '
conData.Execute sql
Record Set
I had a problem that happen once only but i do not want it to repeat
again. It happen when i retrieve data from my database. The process
can't complete and show error 14, Out of string space. I suspect the
recordset object had reach it limit that why it generate that error
message but what can i do to prevent this from happening
Add New Record
I have a siple script where I add a new row in a table which has also a autonumber field. Adding the new row I am trying to get this value of the autonumber field and put it in session, but can not seem to figure out how. I tryed to open a new recordset and pull it out but does not find the record I just added.
View Replies View RelatedRecord Set In My Sql
The only database connection I have ever made using ASP is to an SQL2000 Server. I was just wondering if someone could provide me with a nice simple script opening a connection and recordset to a MySQL database and providing a valid connection string.
View Replies View RelatedAdd Record
Trying to learn a little asp and am trying to have my form (when the submit button is pressed) put the value in a field in my database. it worked the first time, I typed in the word testing and clicked submit.
now whatever I put in there it creates a new field with the word submit. Can someone tell me what I'm doing wrong here? I'm positive there's something wrong with my code here. Code:
If Request("submit")="Submit Questions" Then
Set questionsubmission=connectionToDatabase.Execute("INSERT INTO kitchen_questions(questions) VALUES('" & database_select("questions") & "')")
End If
Record Is The First In A Record Set
I'm looping through a record set and want to treat the first record differently. I've got a counter that I check to determine if its the first iteration through the loop, but I was wondering if there is recordset property that would indicate the record's position in the record set.
View Replies View RelatedGet Record From Db
now i got all my data in my sql db table (fsearch) . now i want to take the value from the db to display it on the browser in the form of a table .
View Replies View RelatedUsing Record Set Twice
i need to use the same record set in my page twice. some optimization issue [img]images/smilies/biggrin.gif[/img][img]images/smilies/biggrin.gif[/img]. i have arecord set like this
Code:
set newsrs=createOBject("ADODB.recordSet" )
newsrs.Open newssql,cnn,3,3
and i wanna use this twice in the same page
Code:
do while not newsrs.eof
newsrs.movenext
loop
can any body tell me how? coz when i do it the second isnot working [img]images/smilies/rolleyes.gif[/img]
Using One Value From A Record Set
I run a query like
SQLSelect ="Select Number,Type,Description,Retainage_Percent from table_name1"
this returns a value for number. then I would like to run another query on another db
SQLSelect2 ="Select Number, Text from table_name2 where table_name2.Number = table_name1.Number
Can't Add Different Record
I didnt know what to title this, so please bear with me. Trying to learn a little asp and am trying to have my form when the submit button is pressed put the value in a field in my database.
it worked the first time, I typed in the word testing and clicked submit. now whatever I put in there it creates a new field with the word submit. Can someone tell me what I'm doing wrong here? I'm positive there's something wrong with my code here.
Code:
If Request("submit")="Submit Questions" Then
Set questionsubmission=connectionToDatabase.Execute("INSERT INTO kitchen_questions(questions) VALUES('" & database_select("questions") & "')")
End If
Querying The First Record
how to locate the first record...i sorted the numbers and i want to display the first record based from the query...
View Replies View RelatedAdd Record On The Database
i use access database and made add record page and it is added on the database then i made another page to add on another table on the same database it is not working i donot know why,and the problem from me or from the server setting???
View Replies View RelatedWant To Change Record
iam having problem ,relating to update a column in Access file in ASP
'Change' is column name , rs is recordset object ,and i want to update the values in 'Change' column by return values from a function .Iam using vb script in asp
rs ("Change").value = function()
this is generating error, and won't work
Empty Record
When there are no records for the certain row in my table I recieve this error:
ADODB.Field error '80020009'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/admin/Fixture.asp, line 0