Dreamweaver created code to update to data base. But when testing on website i get the following message. I have no clue what it might be.
Microsoft JET Database Engine error '80040e14'
Syntax error in UPDATE statement.
/admin/update.asp, line 111
line 11 is strName.execute
I read it might be forbiden characters in the data base field names or spaces...
but i don't have that. the names are userName, userLevel, ID, Password.
Do I create and name all pages with .asp or still in .html. when creating a drop down menu, assuming all the tags are in place, how do i test the site on the server?
so do i create the html pages first or the data base first or does it matter? where is the data base created in notepad or excel?
I have been using php for a while now but have recently had to start using asp. I have purchased some hosting from webfusion.co.uk but have been having trouble connecting to the sql server, could someone possible help me here as I don't know what is the correct code to use to start with let alone know where I have gone wrong.
View Replies View RelatedThis error occured with me when i want to open my access database:
----------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x888 Thread 0x1288 DBC 0x2e8f014 Jet'.
/AAA/Afghanistan.asp, line 374
----------------------------------
I have a data base that I wish to add a record to. I have many fields to ender, but I was testing my code with just one and it works just fine : Code:
View Replies View RelatedIm creating mcq questions using asp and have problems in storing the scores into my database..
View Replies View RelatedI have a few check boxs on a page. What I want to do is if a box is checks a value of Y is stored in the database. Could you please show me how to do this?
View Replies View Relatedhow can i insert the images in any format in MS Access database using the ASP plz give me a simplest and easy code which i can use in ASP
View Replies View RelatedI want to update Excel file when i update database.
View Replies View RelatedIf iam tring to update data to database thro asp coding it is showing error as follows
Microsoft JET Database Engine error '80040e09'
Cannot update. Database or object is read-only. Code:
I want my users to be able to update their data(they store hours spend in different courses per week) stored in the Access database. So far they are able to update only one record(i.e. for only one week).....all they do is search for their records using their User_Id and click the WeekNo they want to update.
when there are (e.g. WeekNo1, WeekNo2.....) the user can only update data for WeekNo1 and when they click WeekNo2 the link takes them to WeekNo1 data.Please guys I need help cos I've been trying so hard to figure out what might be the problem and failed.
I am really having a problem with trying to get my datagrid to update my data base.
I have tried 2 different sets of codes, but when ever I enter the new data to be updated and click update, the datagrid will just return to the orginal datas. There is no updating done. I really am very new to this. Please advice what are the problems in my code that I must change. Code:
I didn't know how to use asp to update or insert the excel data ....
View Replies View Relatedi have an Update button. according to flow operation, after customer clicks the button, the new data will be saved and i want to close the current window automatically. how to that?
View Replies View RelatedI'm using DW MX 2004 to build an asp based eStore. I have a checkout page created with both the billing and shipping information in the same form. I'd like to add some code and a button to activate it to copy the code to the shipping info (but it can't submit form). Also the State choice is a drop down list based on a recordset. There are other behaviors attached.
View Replies View RelatedWe are running into problems with the script below, whose purpose is to allow users to choose values from drop downs populated by an MS Access DB.
THE RESULTS:
(returns a blank page with only HTML Titles)
THE SCRIPT:
(you may notice this is a modified sample script): Code:
This seems a very complicated task, so I welcome any
input. My boss wants a data grid or matrix of the top 6
orders with ordered items, and products, for a particular
customer and he wants to see it like this:
products down the left side
orders across the top
number of items under the respective order number column
across from the corresponding product.
I hope that makes sense.
I have three tables. Products, Orders, Orderitems. I
don't even know where to start. Many thanks in advance
for any input offered.
how do i get data from a user on one page and display the result on the other page
actually i have written a prgoram that displays a set of checkboxes and based on the checkboxes selected the related data is displayed .but the problem is the data is displayed on the same page below the list of check boxes. Code:
I have a form that has the option to upload a file at the bottom. If you select a file it works fine but if you leave file selection blank the forms bombs. This is not how I want it to work. On the form you need to use ENCTYPE="multipart/form-data" in the form tag.
On the processing page I need to use Set to assign a variable to the form data. I tried using IF on the variable assigned to the file path but it bombs out telling me "This function is not supported". Is there any other way I can check to see if curQes has a value assigned to it?
I'm trying to build an application in ASP and using multiple database, but I've receiving some problem, have any idea or have any sample scripts to use multiple database?
View Replies View RelatedI'm using W2k Pro, ASP 3, IIS 5 & DWMX 6.1 and code in VBSCRIPT
I currently use the <BASE href=XXXX> in all my pages and just read
that this tag is no longer supported so will soon vanish
I have a couple of sites that I'm working on and to make all my links
work right etc I need to use the base href tag
http://localhost/site1/
http://localhost/site2/
http://localhost/site3/
where online the base href would be
http://www.site1.com/
http://www.site2.com/
http://www.site3.com/
all my links are like <img src=images/mylogo.gif> or <a
src=info/info.asp>Info</a>
Now my problem is how else would I design my sites if I cant use the
Base href tag so the site would work both on LOCAL & REMOTE servers as
needed in the above paths?I'm sure other people develop on a WIN 2k PRO system where you canonly have ONE site (c:inetputwwwrooot) Which was fine when I only
had one site... but when I needed a second I had to change my first to
use the Base href so I could check the sites out locally (offline)
before uploading them to a live server.
Can anyone point me in the direction of a freely-available Knowledge Base/FAQ script, compatible with iis5 and ms sql.
View Replies View Relatedi wanted to get the 411 on this article. I want to create a small utility web site with a logon page and a form connected to an Access database. The article below explains exactly how but when I try this I can only see the code no actual logon page - nothing but code.
My system is asp allowed and asp.net extensions allowed. FP 2002 extensions allowed. All other extensions are prohibited. I am using w2k3 IIS 6.0 and running 3 html sites succesfully all with working forms. Is there something on the server/website itself I need to enable?Why do I only see code and not a logon page as described in the article?
how do i get a value from a combo box and populate a list box base on the selected value from a combo box? If possible can i get a sample coding.
View Replies View Relatedhow to call a csv file into a data array. I was told I can use :
csvArr = split(csvLine, ",")
So long as I have no embedded commas in any field. what Im not clear on is the syntax.
how do I call the csv into the script (so the script knows to use the csv)
I only want to input the following information if it is not a zero length string. Any
ideas on how to do it?
Crate&Barrel = Request.Form("Crate&Barrel")
Crate&Barreladdress = Request.Form("Crate&Barreladdress")
How can I display data from an XML file in ASP?I want to use an XML file instead of an Access or SQL database and would like to display this information the same as I would if I were using Access or SQL as the datasource.
View Replies View RelatedCan You Grab Data From Multiple Recordsets?I want to build a search page, but I have data in about 6 databases.
View Replies View Relatedhow to add new data. i need to add new data after display the record from database. i click new button and the textbox will be empty. Wat is the code for add new data?
View Replies View Relatedi'm trying to figure out how to use the same page to get different output using .asp?id=.
I have a db table with 5 records & want to on my page to be able to with a listbox/menu be able to switch between these 5 records using the same page.
I had write an asp file to get data from an xml named "data.xml" and below is the coding:
Dim xml
Set xml = Server.CreateObject("Microsoft.XMLDOM")
xml.async = False
xml.load (Server.MapPath("data.xml"))
Dim fText1, fText2
fText1 = xml.documentElement.childNodes(0).text
fText2 = xml.documentElement.childNodes(1).text
Set xml = Nothing
It's all Ok and can run. But my problem here is I want to call an xml file that I don't know its name (not "data.xml"). The xml file pass by the user who call my asp file. The user can pass the xml via anything for example asp or VB component. So I will not know exactly what the name of the xml file.
the actual question is as follows:
i have setup a DSN called "pro"
now i have tables in this database
i m running oracle
if i were using MS Access i know how to insert new fields by using the
RS.Mode = adModeReadWrite
how do i do it for oracle? not just inserting data into tables but also what r the commands that i have to give in the asp code page so that i can even update( edit ) and delete records.
I have a DB called users.mdb and it has the tables:
Myusers-
(fields) ID Name Password DOB Date joined
Messages-
(fields) ID Mailto Mailfrom Subject Content Postdate
I am trying to develop inbox.asp, how do i get it to display the mail for each articular user, and no one elses mail?