basically i have given each customer, in tbl_user, that goes through the first page an "autonumber" (userID) and then each window has this same userID for each window that user selected. so i can then see the relationship between what user wants what windows.
My trouble is that im having difficulty creating a system where the correct userID is entered with the window Code:
I have ASP1 page with few input text fields.All the field have similar name ie testf1, but different id.
eg
<form name="test1">
<input name="testf" id="TF1" type="text" >
<input name="testf" id="TF2" type="text" >
</form>
When I summit this form, It called another asp2.On this asp2, I would like to retrived all the fields values from ASP1, using id.Is there any way I can retreive fields values using id.
I have 2 fields in my table
Warning1
Warning2
They are varchar type and hold date data
So i want to check if todays date is between warning1 and warning 2
strdate=getdate()
strwarn1=rs("Warning1")
strwarn2=rs("Warning2")
str="select * from records where strdate between ('" & strwarn1 & ", " & strwarn2 & "')"
how to selct from a database all records that have the same Company Name and have that information automatically change depending on who is logged in, based on there Company Name.If Acme company has 5 members signed up I want any of those users that login be able to view all other users from that company.Is there a way of writing the script to do this?
View Replies View RelatedI've had a look around for a few hours for a solution to this problem but can't really find one so maybe someone can help or point me in the right direction.I have a database with fields like Name Date Project Hours worked etc and i want to make an online form where the user can type in their name and the date and it will show the record that contains there name and that date.
View Replies View RelatedI am retreiving the records and placing them in the original form with stuff going in its own text boxes and all. i have a few checkboxes and when i retreive the records,i want to even see the checks in the checkboxes.
so that the user can see all the info abt that record and if they want to uncheck any. they can do so. So how do i retreive those checks in the checkboxes?
I on my site i have a form that users fill in, once they have filled it in, they are then redirected to a preview page. All this is fine.
Then users get redirected to a secure third party that takes all the customers credit card details and checks them all.
If they are all authorised then it will the go back to my page to confirm that everything is ok and that their information has now been added.
What the problem is that i can not carry the information through the secure servers pages and what I need to do is basically get the user to fill out the form have it inserted to the database, then they pay for it, If all ok i want to be able to insert a "confirmed" into the payment field for the advert that they have placed or if it fails for it to say "awaiting payment" in the payment field and a message on the screen to tell them to contact sales team.
Let's say that someone trying to insert a record in the primary key which already exist...
it returns an error, and in fact that error:
Error Type:
Microsoft JET Database Engine (0x80004005)
The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again
How can I replace that error with a friendly message such as "that record already exists"
I have 3 tables, product, industry and plist. product has productID and product, industry has industryID and industry, plist has productID foreign key with productID on product table and industryID foreign key with industryID on industry table.
In the plist table I am storing the productID and the industryID's that relate to that productID..
industryID productID
1 4
1 7
1 9
1 10
etc.
What I want in my ASP page is to return the actual products that each industry serves. So for the above example my script should return the products in the product table that relate to the productID's 4, 7, 9, 10, when I search it by industryID 1. I hope this is making sense. Code:
i need to go through a list of items and check to see if items on list 1 are on list 2 and vise-versa. so im going to look at item 1 on list 1, and go through all the items on list 2. if i find a match, ill update the record on list 1, if i dont find a match ill update the record on list 2.
im going to need a nested loop. in c++ i know how i could do this, but im not sure as how to do it in vbs/asp. can you do for each "record" in "myrecordset"? or do i have to get the number of records in the table and run the loop that many times? which would be eaister?
I have a form which only authenticated users can access (Basic Auth against an ADS domain). Currently, I use Request.ServerVariables("LOGON_USER") to display the login name of the user. This information is both displayed and submitted as apart of the form in a hidden field.
What I would like to do is to poupulate the form with user details from an LDAP directory (ADS at this stage, but quite possibly changing to CA eTrust) such as Name, Email Address, and contact numbers. Does anyone know of any resources which might outline how to acheive this, preferably with any code samples to acheive this?
how to display search results on my web site in an order that I specify. at the moment there ordered by the primary key which means there all over the place.I know what the code is but I'm not sure how to use it, can anyone give me a quick lesson, does the code need to be on the search page or the results page?
View Replies View RelatedDoes anyone know how I can open up an entry in a microsoft access database table using its primary key through asp?
View Replies View RelatedI have a table in MS SQL Server 2000 that has 4 fields, one of which is a primary key. How can I insert a new record and have SQL Server automatically handle the primary key field? I've tried the following SQL code:
Code:
INSERT INTO orders(TransCode, TransTime, TransAmount) VALUES ('stuff', 'stuff', 'stuff')
but it fails because the primary key is left NULL. I'm sure there is something really easy that I'm missing here.
Is it possible to ascertain which fields are the primary keys from an Access table just using asp? If so how?
View Replies View RelatedI just want to make the primary key so that it auto increments. Thanks
Code: .....
creating a script that will create a primary key base on the date today and a number ( ex. 1124204-1, 112404-2) with the last number increasing by one. the script should automatically increase the number if the key has already been used.
View Replies View RelatedI have a field couponID as the primary key in my table - when writing the insert statement how do I get the autonumber value to be inserted? below is the code that I have, but it doesn't work
sql="INSERT INTO coupon (Value, ValueSecondLine, ValidThrough)"
sql=sql & " VALUES "
sql=sql & "('" & Request.Form("value") & "',"
sql=sql & "'" & Request.Form("validSecondLine") & "',"
sql=sql & "'" & Request.Form("validThrough") & "')"
conn.Execute sql
I wan to ask isit can generate a primary key before to insert a new record from
asp to database (ms. access 2003). wat coding should i write for generate a primary key
that unique? i cant find a solution to do that. my primary key will be sequences like :M0001, M0002...... follow
isit possible i genrate a primary at ASP pages before store/insert into the database?
I'm looking to display information pulled from a database based on information the user puts into a text box. The user will enter their sales rep number and I want to hit a table and return their name as soon as they tab off of the text box.
View Replies View RelatedI have a table in SQL 2000 with a composite Primary Key on coulumns Instrument_ID (int) and WeekOf (smalldatetime.) I am running asp on win 2003. Code:
View Replies View RelatedMicrosoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Sybase][ODBC Driver]Integrity constraint violation: no primary key value for foreign key 'MemberCode' in table 'PersonMember'
/admin/Member_New-Sybase.asp, line 39
What i am doing is first i have added a record to my persons table the next step is i need to add this person id to the PersonMember table with a new MemberCode and then finally add more information to a membership table. Code:
I created a web page from Excel2000, using "Save as web page..."...Publish
function. then, I moved htm file to my IIS web server. Then I added a form control, and submit button.
How can get the data on the excel file using ASP from server side?
For example, the value of Cell(1,2), Cell(2,3)....
What I want to be able to do is create a user control that will display an
entire page page within it. Does anyone know how to do this or better yet
have any same code?
I like to know how to write this specifc function on ASP where the user eg: display a set of records on the webpage. Example the data are ID, Name and address.
Lets say i display the data on the webpage and i set the Name as the <a href>. So when i click on the name, it will move to another page with the id of the specific name. Code:
I have an ActiveX control in my ASP page that has not been signed yet, so currently just for testing I set the Security for Intranet to "Low". When I run the ASP page on my machine (the IIS is in my machine), I have no problem, except the page prompted me with "An ActiveX control on this page might be unsafe to interact with other parts of the page. Do you want to allow this interaction?"
But, when I run the ASP page on another machine (even though the other machine is also a development machine that already has the ActiveX control and I set the Security for Intranet to "Low"), it did not prompt me the above message, and I got an error when accesing any method of the AX control (e.g Object doesn't support this property or method 'myAXControl.method').
Is this because I have to create a CAB file and mark the AX control as safe for scripting ?To create a CAB file for this AX control, do I need to create my own VB AX
Control project that contains this control and then create a cab file for this VB project ?
This is a standard ASP application that has several pages at the root
withthe global.asa. I set a session variable session("accountid") =
"123456" within an asp page and then response.redirect to the next page and
immediately response.write session("accountid") and I get back nothing.
But if I set a session variable session("accountid") = "123456" within an
asp page and response.redirect to a page in a sub directory and immediately
response.write session("accountid") I get back 123456 on the screen.
I am having a problem with a site that I am developing - my aim is for it to validate as XHTML Strict however, I am running into a couple of problems validating it; in my Response.Write ASP script, I am not including " 's to define page element tags as they keep throwing up errors in the page. Code:
View Replies View RelatedI've a strange problem with Windows Vista, running an ASP page on local
machine (http://localhost/test.asp), the page does not give me any error but
the asp code is not executed (simple code : <% response.write("hello") %),
it show me a blank page, I think I've put all the setttings correctly, but
maybe I must do something obvious to fix that.
I encounter a page reload situation in ASP. It is I need a way to differentiate whether the current page - "Application_Result.asp" got reloaded itself when user click on the browserRefresh button or is requested by the previous page "Application_Form.asp".
I tried using
<%if Request.ServerVariables("REQUEST_METHOD") = "POST" then%>
<!--it is requested from "Application_Form.asp, do something-->
<%else%>
<!--Application_Result.asp refreshed itself(such as user clicks on the
browser Refresh button, do something else-->
<%end if%>
However, in both cases, the IF statement above all evaluated as true. how to differentiate this two different behavior (Page Refresh versus Page requested by another Page) ?
I have page for user to update his/her details. What i want is after idle for more than 20 mins, the page will redirect to login page automatically. So that the user knows that his/her session already expired and need to login again.
But it doesn't working. This is because if he/she update the details (after idle more than 20 mins), and click the Submit button, it will go to login page and all the data will be lost. Code:
I am working with a developer, on two portions to a site, he is working in PHP and my work is done in ASP.
Is it possible for my pages to request data from a cookie that was written by his pages that are PHP but residing on the same server? Just want to make sure before I spend too much time planning out the development on my end.
I have an application which allow users to search our database. Quite a lot
of search fields pull data from other tables. I don't want to populate the
dropdowns (total 14 of them) from the database everytime as it slow the page
load.
Instead I would like to have a link next to the text field which a
user and click and the choices can be displayed and whatever the user click
in the pop up I want to transfer it to the text box and close the popup.
For example there is a Textbox called country. The user can either type in
the country name or click on the link which will pull all the countries from
table in the database and which ever country user selects, the textbox is
popluated with the country name and the pop up closes automatically. Code: