i'm breaking my head with this a hour now Code:
mySQLz="SELECT * FROM services WHERE serdraw=id AND shop="& shopp
call getFromDatabase(mySQLz, rstempz, "mozzzdiyexec.asp")
if not rstempz.eof then
response.redirect "message.asp?message="& Server.Urlencode("aSSSdded")
why this is not working...i almost sure that this is because that line
mySQLz="SELECT * FROM services WHERE serdraw=id AND shop="& shopp
id and shopp are numbers
I've got this PHP script working on one of my sites and now need an ASP version for my intranet. I don't know ASP, can anyone help out?
Know of anyway to NOT have a blank browser window open when clicking on the link or even a better solution to prevent spam harvesters? Code:
I just go an error in an If statement as follow:
If rs.State=0 Or rs.EOF ...
In this particular case, rs.State was 0 and I got an error which is related with the Scripting engine trying to execute rs.EOF which of course through the error.
Is there any way to reach in VBScrit the same meaning of Short Circuit evaluation as C++ and Java do?
I like to pull the top 5 record that are closest to the current date but the date field can not be empty, see some records do not get assigned an expire date and others do. I want to show the closest expiring records.
objconn.commandtext = "SELECT TOP 5 * FROM merchants ORDER BY Expires"
What do I need to add to exclude the emtpy expires field records.
I am having a problem getting a short format november date (e.g. 01/11/2006) to be passed in to an access 97 saved parameter query. October dates work fine but not November dates. Code:
View Replies View RelatedI have a database and i want to work out the sum of the discount field where the id is lets say 1 and the date is greater than 01/02/2006
The database hase records older than 01/02/2006 but I dont want them just the 1s dated 01/02/2006 to now
set RS3 = conn3.execute("select SUM(discount) from restaurantaccounts WHERE restaurantid=1 AND datepaid >=01/02/2006").
This is regarding a change in the Short Date format under Hebrew Regional
Settings, that has caused huge problems in our ASP web application. The
change appears to have been introduced sometime before Windows 2000 Service
Pack 4 and has remained through to Windows XP. I am looking for a solution
that doesn't involve rewriting our application (much) and that allows all
our users to keep using Hebrew Regional Settings.
To summarize our problem - we have an ASP-based intranet web application
that is used in our Israel office. Before we installed Windows 2000 SP4 on
our web server and on the client machines in the office, the application ran
perfectly. Dates appeared on the pages and in input textboxes in the correct
dd/mm/yyyy format. Immediately after installing SP4, dates on the pages and
in input textboxes are formatted as yyyy/mm/dd. This is not just a visual
change, it has caused many functions in the application to break. Code:
I am trying to construct an SQL statement that can grab all of the entries out of a table, where the Date field consists of today's date. The Date field is called 'DateTime' - and it is in a General Date format (DD/MM/YYYY HH:MM:SS). I obviusly want to use an SQL statement like this:
SELECT * FROM tblExample WHERE (DateTime = Date());
However, that wont work because Date() will only return a short date (DD/MM/YYYY).
I'm looking for sample code that will require a use to enter a code from a scued image format.
I'm sure you've seen them before where the image is barely readable by a human and the user has to enter the code correctly to submit the form.
I'm looking for ASP code and NOT ASP.NET code as I am supporting a legacy site.
do you know of any asp code that makes a pdf on the fly.
if there's none do you know of a good, not-so-expensive and easy-to-implement component?
Is there any way that I can store my ASP code in an Access DB and have it display that way? Ideally, I would like to make a page with a text area that I can write and edit code in, and then when I submit it, I would like to view the page that the code creates. The code in the DB would include code that selects from and updates the DB.
I would like to do this because I can't work remotely now.
What is wrong with my code?
This is the error.
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'CLASSDATE >= 6/23/2004 ORDERBY CLASSDATE'.
This is the code.
Code:
strSQL = "Select * FROM WellClass WHERE CLASSDATE >= " & DATE & " ORDERBY CLASSDATE"
I am trying to follow the W3Schools tutorial on the XMLDOM object, and it works fine in a regular HTML document inside <script> tags (vbscript), but I am trying to do it in the ASP tags (<% %>) and it does not work.
The error says:
Code:
Microsoft VBScript runtime (0x800A01A8)
Object required: '[object]'
I am trying to do something with it and I can figure out what to do!I have created a database that lets realtors track clients, potential clients, and offers made. Here is a link to the database:(URL address blocked: See forum rules)
What I am trying to do is create a form that lets a user enter his first name, last name, email, and offer amount into textboxes. When they click send it adds their information to the Potential Buyer table (the primary key is an auto generated number.) The offer table is basically an associative table, containing the following information: buyer$buyerid, client$clientid, and amount. I would like the amount to be added to this table, and I would like it to also add the newly created buyerid. My problem is that well, I have no idea how to do this, as the buyerid is created only seconds before I need to post it in the offer table. Could anyone help me out with this? I'd really appreciate it.
Im a novice with ASP and no idea of PHP, can Any one help me convert this to ASP...
$rss = $_GET['rss'];
if ($rss && $rss != ""){
if ((strpos($rss, "http://") === 0) || (strpos($rss, "https://") === 0)){
readfile($rss);
}
}
Here's the current code that I'm using for navigation through some pages. MY question is, I want the item "System-Add Ons" to still stay bolded if I'm on a page that's in a subset of "Products" Is this possible?
For example, if a user gets to the page "Monitors," (monitors.asp) I want System-Add Ons to stay bolded....
How can I set up subsets of the "Products" page? Do I have to make a directory and do a test if the page is in the directory "Products" and is affiliated with "Products?" Code:
how to get the content or information of other web site using asp code.
View Replies View Relatedis there any way in asp to execute a pop-up window when a condition in an if statement is satisfied
View Replies View RelatedI Wanna to know that which of below codes related to
ADO within ASP (VBscript) is better?
CODE ONE ::
rsEduCalender.CursorLocation=3
With rsEduCalender
if .State=1 then .Close
.Open SQLstr,cn,3,1
End With
'''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''
CODE TWO::
With rsEduCalender
if .State=1 then .Close
.CursorLocation=3
.Open SQLstr,cn,3,1
End With
figure out what the ASP code is to email a form?
View Replies View Relatedi created ASP page for Online TEST
it Consist three pages
First Page is Selection of Topic and Number of Questions from List Box.
Second page is shows the Questions as per the Selection in previous page Datas from the Database.
Third Page is Result Page.
But My problem is in Second Page, because all the question are created dynamicaly so that how can i get the User answer
I get the question id and correct answer for all the questions.
but i need to get the user answer for Result.I attached my code for the second page.
Is there a program or website that will validate my asp pages?Kind
of like how html pages can be validated on
http://www2.imagiware.com/RxHTML/ and on http://netmechanic.com
this is what i am doing for zip codes
i want user to enter zip codes like this
92274
92274-0965
so if the user enters zip code like this 92274 then its right
but if he enters zip codes like this 922740965 then change it to 92274-0965
this is what i have done so far so i have got the values of first 5 i need to include a -and then the rest of the numbers any idea how to make this work
I need some code to test whether my connection is open in an asp page. Something like this:
<%
IF NOT connection is open THEN
Connection string code here
END IF
%>
I know how to write the connection string, it's the first part of testing whether it's closed or not that I don't know.
I have two tables, raceresultsview and jockeyselections.
In jockeyselections, I have jockey names and stableid, for example Pat
Day, stableid 1000.In raceresultsview, I have jockey names, and placement.
I want to do something like this:
select * from raceresultsview where jockey in (select jockey from
jockeyselections). This works FINE, but I need to figure out how to grab
the stableid, too.Each time there is a match, I want to insert the stableid and placement
into the table named winnings.
in 3 tier wed based application ..i want to run my vb code seprate for debug purpose...how can i do this>
View Replies View RelatedHeres my for next loop. Basically it is pulling files from a folder. Now I want it so that if it reaches the end of all of the files, that it starts over at the beginning. Any ideas? Code:
View Replies View RelatedThis what I am doing:
Moderator (from admin) will see a list of cities to approve/decline.
If approved, then the city will show up in the search and alert city list
boxes.
If declined, then the moderator will be asked to pick an approved alternate
city and all postings containing the user-inputted city name will be changed
to the alternate approved city name.
The moderator will be notified via email when not listed is selected.
Any one have any ideas on how to build this in ASP? I'm kinda new to this
ASP programming thing.
I'm looking for a script that will auto complete the state field when someone enters their zipcode.
I'm currently using http://javascript.internet.com/forms/zip-to-state.html but its kind of out dated and often returns null. Does anyone know of a more up-to-date version or one that is updated regularly? It doesn't have to be free.
Can anybody tell me about this:
conn.ConnectionString = "SELECT [Customernr], [Customername],
[OrderID], [Orderdate], [Itemname], [Ordersum], [Orderdiscount],
[Orderprice], [Orderamount] " + "
" +
"WHERE Customernr = "' + <%txtCustnr.Text %+ '" FROM
[CustomerOrderHistory] ORDER BY [Orderdate]";
So what I try to obtain is getting a value from a textbox: txtCustnr.The code is C# in an ASP 2.0 application
This was originally posted to Macromedia forum but maybe someone here can assist.......
I am a total Newbie to ASP and forums....trying to begin dynamic site building....purchased almost all Sitepoint books trying to determine if ASP, PHP or which is best/easier......
Simple ASP file failing.......also SMTP e-mail from form
Using Training from the source book - Dreamweaver MX dynamic sites.......but software is actually Studio MX 2004, running on Windows 2000 platform using local Microsoft IIS as testing server.... Code:
I learned basic ASP at a computer trade school where it involved sql. After buying webspace from a host, I later learn they do not support sql, only ms access. I've been using code that deals with sql, but at the same time my database has been done in access.
my host has on several occasions been called to fix server side problems, but now it seems only my code is at fault. it tells me the exact line with the problem, but i can find nothing wrong with it, mind you im not very experienced. im hoping that perhaps you will be able to set me straight with this problem. below is the line of code that is erroneous.
Response.Write("<a href=http://fireXdrake.bizland.com/asp/price.asp" & "?id=" & rs(0) & ">" & rs(1) & "</a><br />")..
From where I can get free ASP script like ASPIN.com or Hotscripts.com uses to show product and programs with there ratings and searching options. I need same script as ASPIN.com or Hotscripts.com use to desplay product information.
View Replies View Related