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 & "')"
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.
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 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.
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?
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 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?
I'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:
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.
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?
how 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?
some way to access to the content of the HTTP POST? Perhaps throw the request object or something similar to the $HTTP_RAW_POST_DATA gobal variable available in PHP.
View Replies View RelatedI am having a lot of problems with this, I am trying to create a pdf file from data submitted by the user via a form.
Once the details are in the PDF the file needs moving into the secure area of the site.
Anyone have a clue how to do this?
i am trying to use AJAX to get XML data from 3rd party site and display on my site. it works in IE, but does not work in Mozilla. i want to find a method where i can do that.
View Replies View RelatedIs it possible to write out the contents of a database into an exel-type
spreadsheet within an asp page?
I got a database with user and email in it. Now I want when a user logs into my page that it automaticly fills in the email into a email form. How can I do that in Asp.
View Replies View RelatedI want to fix this problem, i dont no how. Bassicly there is blank data appearing in my database, for no apparant reason! Code:
View Replies View Relatedanyone know any homepage that might help me to list the data out in a page. i wanna do it like in 2pages that one is going to be the one who maintain data. another one is to list all the data out from server...
View Replies View RelatedI have two tables having similiar columns ( i had to do this to compare the values given to me, because both the table data came from different sources)
The tables named are
OFFICERS
token
full_name
division
EMPLOYEE
token
full_name
division
Now the table EMPLOYEE contains more than 5000 records and the table OFFICERS contains around 2400 records which are already present in the EMPLOYEE table.
Now I want to build a query that will return me all the records in the EMPLOYEE table that are not present in the OFFICERS table. The criteria for comparing 'full_name'. so the query should return me 2600 records that are not present in the OFFICERS TABLE.
I tried doing this
" SELECT DISTINCT EMPLOYEE.full_name,EMPLOYEE.token,FROM EMPLOYEE,OFFICERS WHERE EMPLOYEE.full_name<> OFFICERS.full_name"
But this query returns me records that is not present in the OFFICERS table as well as some more 1000 records which are present in both tables.
thanks a lot