I am gathering the input values to a form using Request.form method from the processing page. After all the data is captured, I am building sql statement out of it.
Using a response.write statement, I am generating the output of the sql statement which I can ran against the table to insert the row.
However, when I am trying to programmatically use the sql statement for the insert, I am having the following error:
actually i am doing php and know how to handle 404 error page not found errors but one of my client needs it in ASP and i am not that much faimliar with ASP. so i need some help if some body could give me code to handle these broken links .
actually it has to be done like this that if user clicks some where on the site and that page does not exist so the programme should take him/her to a page where message will show e.g 'this page doesn't exist'.
I have a page where user can enter data, which will be saved in the database. I want to handle the closing of window, by clicking on the 'X' of IE. The user should be Displayed a message asking him if he wants to save the data. If yes then submit the same page to save the data and then close the page, else close the page.
I tried to use the 'OnBeforeUnload' event but not able to submit the page while closing. if this can be done. Please send me links useful in this context.
Supressing the "Save password" prompt: Are there any good approaches to keeping a password from being stored client-side if auto-fill is on? Ideally I'd like to supress the prompt. The only other option I can find is to use a timestamp as part of the form name and pass it (the name as well as the value) in a hidden field to the login script.
Unique concurrent logins: Are there any good ways to prevent userX from being logged in from 3 different locations simultaneously? -I can code for a 'logged in / out" field, but that relies on the user actually login out. And if I use a variation of the "who's online" approach the user may have to wait until the seeion expires befor logging in again (suppose thier net connection dropped for a moment and they need to get back online) - At least I think this assumption is correct.
I have some javascript code which executes once the page is loaded. But When user refreshes the pages this javascript is executing again resulting in additional data. I want to prevent this reexecution of data. I tried doing this javascript in many ways But I filed miserabley.
I tried using Session variables also but they are not working properly.
I have created an empty table(.mdb) with 2 columns
Order(AutoNumber) and BuildingID(text)
and i use :
cn.execute "Insert into [Temp](BuildingID) values ("&Buildingid&") "
to insert buildingID into the table
however all buildingid start with 0 with be omitted,
eg. buildingid = "00003333" after insert into the table become "3333"
i have checked that response.write len(buildingid) = 8
What is the problems?
I am trying to make a page post.asp with a form that simply submits one text value and two hidden values into a table. I already have the function that takes the 3 parameters, modifies them and successfully inserts them into the table:
I have included this function in this post.asp page ...
I want to capture err.description into asp variable when any error occurs in the pages as a whole. Suppose some error occurs at the top of the page say ADO Block.
Can it will travel till page end, or can every error necessarily stop the proceedings and throw error resulting page crash. My ultimate aim is to capture error in asp variable when ever crashable error occurs. How to capture it. Code:
I would like to clean up my mailing list by changing the URL I use at the moment which is in the format
www.mysite.com/view_pic.asp?pic_number=123
To be
http://www.mysite.com/view_pic.asp?p...il=bob@bob.com
it would then insert the email into a table, collect these for a while and only see these as active members.Any ideas how to do this, I've tried a few things but no luck.
I have a problem that it's bothering me for some time now and i will need a lot of help from you. I don't know how easy or difficult it is to be done but i would appreciate any help.
I have an mssql 2000 db with table "table1". Attributes for "table1" are:
ID (Primary Key)
field1
field2
field3
field4
field5
field6
field7
I'm trying through DreamWeaver MX to create a form through ASP and Text Fields, so that i can update "table1" through the form and also on another page to show the results of my table.
I have created a form which will be accepting 25 rows, each row having field1, field2, .., field7.
I cannot seem to get it to update "table1".
Any ideas how this can be done?
Does anyone know how to insert multiple records in the same table at the same time. This is what I have. I have a form with 6 fields and they are name prod1 through to prod 6. The table is called related products.
Basically this table is related to the main table called prod_parent. tried looking on google and couldn't find anything.
I am having terrible time in converting a string to a datetime field in my asp page. I am keep on getting error on the following stateement. What would be the correct syntax on converting string to datetime for inserting into a sql table?? I did write the add_str out on the browser, everything looks correct...
Error message:
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting datetime from character string. Code:
I am trying to retrieve a record identity from a SQL Server auto-incremented field on insert statement.
Here is the error I am getting can anyone please help me
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value for identity column in table 'cwm_Report_Request_Form' when IDENTITY_INSERT is set to OFF.
/cwm/Admin/reportrequest.asp, line 66
here is my code:
Preparing a report form in word file using ASP.
How to insert page breaks in word file through ASP to perform a
client side report.
We're working on an online application system - I've got a form that allows an applicant to upload a resume, references and supplemental material: Code:
View Replies View Relatedgot some problems inserting a simple flash movie within an ASP page. Actually i am working with Dreamweaver and when I test my page from PWS directory, the flash movie keeps on loading..can't get the flash movie, but when I test the movie outside PWS, it does play the movie.. Should I include any file within the PWS root directory?
View Replies View RelatedI'm trying to insert records into an SQL database coming from a page using the request
..form method. The table "general" has a primary key 'geid .' I get the following error:
Cannot insert the value NULL into column 'geid', table 'general';
column does not allow nulls. INSERT fails.
....not sure how to include the 'geid' field into the scheme.
strSql = "insert into general (firstname,surname,company) values ('"
strSql = StrSql & Request.Form("firstname") & "', '"
strSql = StrSql & Request.Form("surname") & "', '"
strSql = StrSql & Request.Form("company") & "')"
myconn.Execute (StrSql) ....
what I want to make actually is to take the results of a search engine that I use, which are in form of HTML or ASP and transport that results in a DataBase. For example, I wont to place as registrations in the DataBase the equivalents URLs and their descriptions from the results of search. I use MS Access, code asp, HTML , Javascript .
QUESTION! How can I insert the content from an HTML or ASP page into a dataBase? How can I determine from what point to what point a string it will be entered in the first cell of table and afterwards in the next and next ....
I have defined a recordset in Dreamweaver to retreive information from an Access Database Table, but everytime I try to insert a master detail page, a dialog box asks me to first create a recordset, which I already did. Any thoughts on why it keeps doing this?
View Replies View RelatedI need to solve this as part of a class project. It is designed to simply read a SQL table and display the data in the browser. But it will only show one record based on ID at a time. So if I have multiple records with the same ID such as page.asp?ID=9734, it would show all records using that ID in the browser. Code:
View Replies View RelatedI have 2 .ascx files and one .htm file. One of the .ascx files is basically just a table with four rows. One of the rows has table for the other .ascx file, which is the menu, and the .htm file, which is the body content. Code:
View Replies View Relatedi have a form that action is set to itself, on the same page i m having the insert statement, executed when i submit that form, but when the user refresh that page the query is executed and submit the null values in the table.
<form name=form1 action=form1.asp method=post>
<input type........
<input type.......
<input type=submit value....>
<input type=hidden name='insert' value=1>
</form>
<%
if request.form("insert") = 1 then
Execute the insert query
End If
%>
My website is currently made up of HTML pages and residing on a Windows server.
Currently converting them all to ASP, that is going from .html extensions to .asp (besides adding funking asp functions)
My pages have all being indexed by Google, so wouldn't risk loosing good ranking with Javascript redirects, so I tought using this would solve the issue, for example, on a file named thatpage.html
<SCRIPT LANGUAGE="VBSCRIPT" runat="server">
Response.Status="301 Moved Permanently"
Response.AddHeader "Location", "http://www.mywebsite.com/thatpage.asp"
</SCRIPT>
Wherever where I insert it, in the head, in the body, before the DOC, it's not working, will have to resort to javascript? Will I have to put a link in the html page leading to the asp page? Wouldn't like to have user click agin to be led to the .asp version?
I allow my users to upload a picture from their machine to my website on the server. I know the exact name and the path of the uploaded picture in my server, is something like:
D:hostingmysitedbgraphicspicturename.gif
Then, I would like to insert this picture into my home page. How can I do that without manually download the picture from server to my machine? How can I insert a picture that exist in my server into my page?
I would like to show my data in a ASP table. I do not want a sort of record selector on that page. So I did the following: Please be as kind and look the attachment
I would like to see a table header like "tradeid,clearingnumber" etc - and underneath the list of records.
can someone tell me how to get this because in the moment I only see one record always it's not continuing writing the list.
Does anyone know where I can find an easy example of how to read an Excel or XML file and automatically populate a table on a ASP page?
I want to create an asp page that has a table on it that reads from a XML or Excel file so I can update the file and the table information changes accordingly. I know this has to be somewhat simple but I cant seem to find any exmaples. I probably am not searching the right keywords or something.
Any suggestions on where to find an example script to do this?
I'm trying to put the 4 latest(by publication date) articles published in my press table on the front page of my site. What's the logic here:
Show only the 4 latest articles
and if there is no addition to the article db:
Show latest articles for 1 month.
I connected MS Exchange Server to MS Access database using Access link
table function. I can open the database table and see the fields and
data inside the link table. However, the table seems cannot be queried
by SQL statement.
My situation is:
I'm building an intranet. I have a ASP login page for all staff in the
company to login. Other people can't register or login the intranet.
That's the reason I use the company email address to verify username
login name.
After I made the link to the Global Address List (rename to
StaffList), I can see the Alias field. I wrote ASP code to use Alias
field to verify user login name. But, the ASP page seems experiencing
difficulties. I always got the "Connection Timeout" Error. Code:
I'm trying to display records from an MS Access DB (*.mdb) in an ASP page (table).. I don't want to display all the records though, I just want to display the total of these records..i.e in my table I would like to show how many calls someone has closed this year..(number)
Joe Bloggs ---> 100 Closed
Is this possible? I was thinking that I need to write an ADO that includes COUNT but I'm not too sure how to write this.. Here's what I have so far: Code:
How to prevent duplicate values when using BULK INSERT to insert CSV to SQL Server? Code:
View Replies View RelatedI have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?
<%
Dim conn
Dim rs
Dim MYSQL,MYSQL2
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Recordset")
conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa"
conn.Open
startdate=request("tarikh1")
enddate=request("tarikh2")
MYSQL = "SELECT * FROM table_x where paymentdate between '" & tarikh1 & "' and '" & tarikh2 & "'"
rs.open MYSQL,conn ....
I have a table having 3 columns. There is a checkbox for each line. I
need to get those lines whose checkboxes are checked, and show those
lines to another webpage. Is there any way to do that? My concern is
that all information in the table are in <tb></tb> pairs without any
name tag. Any idea?
I am trying to display the content of a Table called
'Order Detail' directly from the database (e.g., Northwind.mdb). I have the following commands:
Set tableSet = Server.CreateObject("ADODB.Recordset")
tableSet.Open table_name, DB_name, adOpenForwardOnly, _
adLockOptimistic, adCmdTable
where, table_name = ''Order Detail" Or
table_name = 'Order Detail' Or different variations.
I always get error on the second command with the following message:
Syntax error in query. Incomplete query clause
which I believe because of space in the Table Name. How can I resolve this issue? (working with file or table name with space)?