I have designed an e-commerce site for a friend and he now wants to add promotional codes to the site t work as follows:
The first 100 users to subscribe to the mailing list will be sent a promotional code be the site owner (via email) entitling them to 25% off their next purchase.
What I want to know is the bet way to implement this using ASP and access and also how to ensure that once a Code has been used by a visitor then it cant be reused again.
I am working on this form. One of the text field I am using is for a Special Promotion Code. If the user enters the incorrect Promotion Code it should generate an error message. In the future this text field may have at least 10 valid promotion codes to this field. Currently I have only two valid promotion codes to the the text field. The code I created will only validate the first on (06teach)instead of both. Here's my code...
View Replies View RelatedWe have "orders" that are entered into our database through a data entry web-based application that we've built.Typically,the user enters the city/state/zip code/county. Now they want it to be able to autopopulate the city/state/county based on entering only the Zip Code.
We realize this can be a problem as Zip Codes can overlap different counties/cities/etc.Is there a good way to handle this?Perhaps some kind of control we can use on an ASP page that will read our Zip Code data and handle this somehow?
Having a problem with a page being skipped in the cart. Intermitting problem here. Action code 38 then 47 when this occurs.
View Replies View RelatedI have included all the db scripts in asp above the <head> tag and <html> opener tag.When i submit a page, to add a record that record just get doubled and i dont know why that is happening.It dont happen always but now and then. The problem is not with cliking the submit button twice. So all i want to know is if it may be a problem with including the asp codes above the html tag or not?
View Replies View RelatedDoes anyone have codes or articles related how to make Yahoo-like directory-based serach engine which the categories of the post can be change from one to another, theoretically expandable to unlimited level of directories, etc.
View Replies View RelatedI'm working to revise some code I had the misfortune of inheriting and am hoping someone can either give me a quick explanation or link to some more information. I need to figure out how I can edit a constant.
Specifically, I keep coming across things like
const MN_DIRECTORY=1
const DIR_RESUME_URL=22
and I need to know a.) what the values mean and b.) how I can edit these.
the code for validation? What I'm trying to do is if a person forgets to fill out something on a form...I want a pop up that will remind them what information they forgot to fill in. For example "Please enter your name before submission."
View Replies View RelatedI would like to write ASP error codes in a log file. Error message would be
for example:
ADODB.Fields error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name
or ordinal.
/ASP-application/page1.asp, line 67
I've learned that it is possible to get some information with the
'err-object' of VB. Unfortunately these codes and descriptions are not that
good as the ones ASP itself generates. First of all I'm interested in the
description ("Item cannot be found in..") and the line in the ASP-Page where
the error occurs.
Does anybody know how to catch this information?
I am trying to find a software that can find distance between two ZIP codes. I think most of them do it by having the longtitude and latidute of each ZIP, and substract. But this gives the air distance. Where can I find software that find the ground distance (like in Mapquest).
View Replies View RelatedDoes anyone out there know how to encrypt the entire ASP file? That means when a person tries to view my ASP source code, it will display as rubbish. Can't use Script Encoder (srcenc.exe) cause out there in the market exist a freeware Script Decoder (scrdec.exe) which can easily decode back the file to its original state.
View Replies View RelatedI have a stored procedure that builds and sends an email using xp_sendmail. It is called after the user makes a change to a form (it tells the support centre that a change has occurred.)
The last bit of my SP is this:
-- It fails if it has no recipient list
if isnull(@recip, '') = '' set @recip = @supportemail
declare @rc int -- have also tried changing it to bit
exec @rc = master..xp_sendmail
@recipients = @supportemail
, @message = @msg
, @subject = @subj
, @no_output = 'False'
, @query = @q
, @width = 200
/*
Return Code Values
0 (success) or 1 (failure)
*/
select @rc
return @rc
If I call it through query analyzer, @rc is 0 and I receive the email.
If I call it through my ASP page (which worked earlier), cint(rs.fields(0)) is -1 and I do not get the email.
strSQL = "exec pr_EmailNotification " & iRequestID
writeline "<P>" & strSQL
set rs = ConnObj.Execute (strSQL)
writeline "<P> Result: " & cint(rs.fields(0)) '0 (success) or 1 (failure)
(All variables are declared.)
It was working earlier, I had proven it... I thought it was the return @rc line that was doing it and was just keeping in select @rc for debugging. When I was ready to move on, I removed my debug statement, and then it started failing. I've put it back in, but it still fails, so I must have also removed something else, or changed something, or something.
I'm at wits end. It still works perfectly through Query Analyzer. But not ASP.
when i try to view an ASP page in my IE web browser, all i see are the codes used to design the page but when i preview 'em in Dreamweaver its okay.Why is it so ?does it mean if i publish my asp pages to the web; thats how they'll be on other people's browsers ?what do i do to be able to see the actual web page and not the codes in an ASP page.
View Replies View RelatedIs there any sample codes/projects that does auction website ?
View Replies View RelatedI have created a form with the folowing properties, first name, last name, registration number; course; grade etc I have passed this form to a page to be called create_table.asp, and on submitting the form.
I want this page (create_table) use the info from the form to create tables in an access database (jacko) each time the submit button is pressed with the tables to be named automatically according to the convention fname_lname. I also want to create a page that I can use to edit all the tables in the database can any guru assist me with the required asp codes.
anyone knows what the formula is for finding a distance betweeen 2 zip codes?
View Replies View RelatedI'm now doing a project about handphone making a call and sending sms or mms by using vb.net.
But i need to make the button invisible inorber to see the buttons of my phone.when i switch the visible to false.
The button become inactive and i can't even click it. How to make the button active and it is invisible at the same time. Need to figure out the codes fast,running out of time to do the project.
I have a table with data in it and i want to generate unique icodes for each user. I have a hex function that generates random code but i get stuck when i want the items to be unique. I want to update all uses that have empty codes. How will i go about this. Code:
str_sql = "update tbluser set [usercat]='" & strcode & "' where usercat=null"
conn.execute(str_sql)
I have made a booking system, but need to somehow generate a unique confirmation code to be sent to the bookee to confirm the booking. I hve done a basic Google search, and a search through the archives of the forum, but to no avail.
View Replies View Relatedmy database is database.mdb
my file path is C:Inetpubwwwrootfypdatabase.mdb
Error Type:
Microsoft VBScript runtime (0x800A0009)
Subscript out of range: ''
Besides using this ASP code of opening up my database is here any other way??? I often get the above error due to " This is my present code..
<%
dim objConn, path
set objConn = server.createobject("ADODB.connection")
path = "C:Inetpubwwwrootfypdatabase.mdb"
objConn.open "driver={Microsoft Access Driver (*.mdb)};dbq="& path &";"
%>
I am studying Programming and Computer Engineering and got an assignment. I made a lamp kit and a program, but I now need to integrate both by using ASP. So, when somebody is in the ASP page and presses a certain button, the lamp needs to automatically switch on (or off).
This of course not only applies to a lamp but should be used for different devices. The logic is that no matter where you are or what time it is, you can remotely switch devices on or off using ASP.
My question is: What codes do I need to make this work? And what are the steps to follow?
Does anyone know where I can get a free list/database of all US zip codes as well as latitude and longitudes? I am attempting to create a distance calculator but need that information.
View Replies View RelatedAlright, in regards to my previous post of finding a DB that has all of the latitude/longitudes in a DB, I need to now filter through those based on search criteria. The search criteria available includes: Code:
View Replies View RelatedI have a product that when scanned into the web site will scan as a single piece of string but it is really made out of start code - A0, componeneet code - 00150, stop code 3B, how could I drop prefix and sufix when the product is scanned so it only scans the actual product code.
View Replies View Related