Can someone point me in the right direction on this? There are 3
fields in the DB: model, rma, bagqty. If the values on a certain row
are I530, 1108, 50 and a user goes to input the same data I dont want
the insert to be allowed and force a new insert.
I dont need someone to do this for nor do I want that, just need a push
in the right direction.
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 RelatedIs it possible to, whilst inserting a new record, use a session variable from a previous page for one of the fields?
View Replies View Relatedam trying to get my ASP page to write session variables into an Access database. However I'm getting error messages. I'm not sure if I used the right syntax (using double " for example) Can anyone see a problem:
'Command1.CommandText = "INSERT INTO tbl_quotewedding (coverllevel, weddingdate, marqueecover, publicliability, quote) VALUES ('"" & session(""svCoverLevel"") & ""','"" & session(""svWeddingDate"") & ""','"" & session(""svMarqueeCover"") & ""','"" & session(""svPubLiab"") & ""','"" & session(""svTotalCost"") & ')"
I know that the code below works OK so it must be something to do with how I've included the session variables
Command1.CommandText = "INSERT INTO tbl_quotewedding (coverllevel, weddingdate, marqueecover, publicliability, quote) VALUES ('silver', '30/11/2004', 'No', 'No', '55')"
ive created a database using access, and ive successfully created a ole db connection to a webpage using dreamweaver. i can view records without any problems but when i try to add a record tothe database from a webpage form i get the following error msg
Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.
/guitarguide/guestbook.asp, line 115,
the field names in the database table start with txt_ e.g. txt_name, txt_email etc.
need to retrieve a record from a table (tblBookingForm) in one database and insert it into a table (tblNetServ) in another database on the same server,leaving the original record in place.Cant get my head round it though, doesn't seem to want to connect to 2 databases at the same time.
View Replies View RelatedI want to submit a record to my db via a simple form but return the user to the same page upon submission ie place a form on index.asp and the form action="index.asp".
My logic isn't quite right, can someone guide me in the right direction? This is what I have, upon submitting the details the page just reloads and the record is not inserted.
<form method="post" action="index.asp">Name<br><input type="text" name="Name" id="name"><br>Email<br><input type="text" name="Email" id="email"><br><input type="submit" name="submit" value="submit"></form>
<%
If Request.Form("submit") = "submit" then
call MailList
End If
%>
I am inserting a record into a table to hold information about photos and what to create a folder with the same name as the primary key value of the inserted record. Eg if I have a table (tblAlbum) with two fields (albumID, albumName) and run an insert statement 'INSERT INTO tblAlbum (albumName) VALUES ('test album')`.
I want to then create a folder with the new value for albumID. How do I retrieve this new value just created?
I am using Dreamweaver to create the insert record code for an access database. When it adds the code, I can not see the page on the website. If I remove the code the page works fine. I'm not sure what is going on?
View Replies View Relatedi have an access database that has an autonumber as the keyfield. how do i add a record with the autonumber left out so it is put in automatically by the database. i have this at present as my sql statement but dont know what to put in for the autonumber:
Code:
sqlstr = "INSERT INTO Jobs VALUES (" & " " & ",'" & JobName & "','" & Company & "','" & JobField & "','" & Contact & "','" & Website & "','" & Desc & "','" & Salary & "','" & Picture & "')"
the autonumber is the first record in the table
i am trying to insert a new record in access using vb language in asp it just insert the id which is a auto number here is my code:
View Replies View RelatedJust a quick question more about the flow of an asp page. IF I have code as
below: -
MyDBConnection.Execute "Insert Record Into A Table"
MyRecordset.Open "Retreive the same record from the table"
Is there any chance that the connection process (Inserting the record) will
not have completed by the time I try to retrieve the record. I.E. will the
asp page wait for the insert to complete before continuing to open it (the
next command in the page).
i want to insert some records to Access Database using the checkbox.i've try all the example i've found but it does't work.it's like checking our yahoomail.but i want all the tick checkbox insert to database
View Replies View RelatedI want to insert a record into a DB and then immediately recall what
the ID is. I have heard that there is a way to do this with SQL Server
(although I haven't done it yet). Unfortunately this is for Access.
I've done some workarounds for this in the past but want to know if
there are better ways. What I've done in the past is to recall the
file name or something from the FORM collection against the DB
(assuming this file is unique).
Using aspupload, if the overwrite
attribute is set for FALSE I can use that as a way to better ensure the
file name is unique as it renames the file if it is not unique. The
problem is I need to to this without aspupload now.
I had thought of recalling the last record ID from the DB on the FORM
side and putting it in a hidden field but this seems risky. Any
suggestions?
I have to compare 2 tables: orderA and orderB, if the record exists in both table orderB and orderA, just do a update to the quantity field in orderB (add orderA.quantity to orderB.quantity). Otherwise a new record has to be insert into orderB.
Do I have to loop through the recordset of orderB, then use select statement to see whether the record exists in orderA or not, and determine whether to update/insert record? I am using Access database. I just afraid that looping through each record in recordset (maybe >=30 record each time) would make the transaction getting slow (or even hang??). Can I do this in one SQL statement?
Working on a order sys for a client. I go to create an order, no problem IF There are no other records in a specific table. It is working like this:
create order #1...creates "order" in order table and adds 1st item in orderdetail table...add items to order in orderdetail table...no error.
create order #2...creates "order" and gives an "HTTP 500 - Internal server error".
this involves one ASP page, two tables and one SP. Here they are: Code:
I am trying to insert multiple records into Access DB from a form. Code:
View Replies View RelatedI have a quick question regarding a text field for inserting record, I have a page which inserts various fields including area code an phone number for a new record, however I am curious if there is a way that I can either make the area code appear with brackets around it in the text field which is sent so that the user does not have to type it in each time.
I was thinking I could concantenate the value i send in each time with brackets but am not sure what the syntax would b for this. or perhaps there is another way of doing this?
I have a database in which I have to on a daily basis enter the information for that day. I would like to update this on a bi-hourly basis to prevent any possible data loss.
Using INSERT INTO, I create a new table line. Using UPDATE, I get an error on the inital creation of the table line.I am really unsure how to check to see if that line exists or if there is an easier way around this.
Is it possible to use CDONTS to send an email and INSERT a record to a database, once a form has been submitted. They work individually but I cant get the scripts to work together.
View Replies View RelatedI'm having a trouble to insert data into the database. I can't understand what do I do wrong. I've got 2 pages , one is html with user registration form and another one is asp with the following code:
View Replies View RelatedA page displays the Product literature that a customer can request to receive by postal mail by clicking a check box. The literature selections are created by a dynamic record set based upon what the company enters into the Literature table (currently 10 selections). The checkbox form tags are:
<input type="checkbox" name="LiteratureID" value="<%= rs("LiteratureID")%>">
LiteratureID is the Access autonumber primary key field. I can use the LiteratureName in the "name" attribute if it is easier.
The form processing page needs to Insert each selection into its own record in another table. This "requested" table also inserts the database ID for the customer that is created after first inserting the customer contact info. In other words the "requested" table needs to record the customer autonumbered db ID and each selected checkbox value.
Here is my current code:
I am trying insert a record to my database from my webpage customeradd2.asp Code:
View Replies View RelatedI'm using DreamWeaver MX 2004. I'm wondering is there a way to have 2 (or 3) submit buttons in the one form, each one to insert the record & then redirect to different pages, depending on which button is clicked?
I'm thinking about submitting all forms to one page & have that redirect based on a URL/ Form parameter. Just curious as to other methods.
i need help about restricting pages other than home page
i have a project inserting resume details here
i have 4 pages include home page
if i want to restict all the pages except home page
while starting
how to write asp code for that one
i have a signup form in Macromedia flash which posts the details from input boxes to a database, this is the asp file Code:
View Replies View RelatedI have an ASP page that I want to allow access from only from a certain block of address, can someone get me started?
View Replies View RelatedI'm trying to restrict access to a page based on a session variable called MemberUserID, so the way I thought of doing it was to say if MemberUserID is not equal to this value, then you would get an error page, but the operator I'm trying to use is giving me an error:
<%
If Session("MemberUserID") != Name Then
Response.Redirect "error.asp"
End If
%>
is there a better way to do this?
How can one restrict what kind of web browser users use to view your web site. I only want users to be able to browse my web site using firefox. I know this is possible because I've seen others do it. I'm just tired of it working fine on firefox and not right on other browsers.
View Replies View RelatedI know I'm doing something simple wrong here and it's doing my head in. Don't know if anyone can help without me posting yards of code? I am using normal login page in dreamweaver which uses record id as the username and users password as password.
This all works fine logs in and forwards to /ammend.asp?id=7295 which is also restricted, then the user can update their record, no problems so far. The problem is that if I change the ?id= to another number 7687 for instance in the browser then the user has access to that record 7687 when I though it should go back to the login page.
I am running a virtual hosting server. The configuration of server is
as follows:
Windows 2000
IIS 5.0
All the virtual hosting sites are running as seperate user ie for the
site www.xxx.com is running under xxxIIS and www.yyy.com is running as
yyyIIS. I have also taken some precautionary file system security
measures like the group everyone is not present in c: and directories
corresponding to sites. But at the same time I can not remove everyone
access from the full system, I will need to keep them in few
directories.
This can lead to an asp code that is present on the server to do stuff
like browsing through the file system, reading the contents of file
etc. For ex if I have everyone acccess to c:winntsystem32 then any
person on the server can write code to view the contents inside
folder.
I want to know if there is any way to restrict the script belonging to
one virtual hosting site to access only the contents of that site.
example the site www.xxx.com present inside
c:inetpubwwwrootwww.xxx.com directory and can access only the
contents inside this and the child directories. Is this possible? I
searched the on google but could not find any link that gives me any
information on this. It will really be a valuable information to me.
I have big problem because i need to link site and one service. I have customer with his site and about 1000 html pages which he want to be restricted. So we prolly need to do changes in that html pages...
Other thing is that part of site would be avaliable via payment thorugh SMS service. SO basicaly u go to one site, send SMS with instructions, and that service send u SMS with random generated password.
Then user need to go back to site and login using that random generated password. Can this be done and in what way. We have this system working in php but i dont have much ideas how to use this in ASP specialy with random passwords. I have some asp scripts that restrict pages but ofc users and pwd must be defined in access/SQL which is problem here regarding i dont have user/pwd i only have random generated code:
I have a problem with restricting multiple users to get access to my site with the same username and password.
I allready set up a table getting the UserID of the user and putting it in the table, therefore restricting access for future logins as long as the users Session is still valid.
Now to my problem. When the user logs out everything is great, but when he just closes IE the session is still valid and the field in the DB will not be deleted. I have put a SQL in the Sessoin_OnEnd in the global.asa file, but since this site is a micro site in another folder than the root, the global.asa can effect the main site aswell. And it will take at least 15 minutes before he can login again (and I do not want to set session.timeout any lower).