Conditional Compilation
One of my asp pages can be loaded in two ways - it may be submitted to itself (and therefore contains user data) or it can be loaded by clicking on a link on my menu, and consequently all fields are empty.
If the fields contain values (ie. the submit button was pressed), i want to load data from my database into an array, but if it is accessed via a link, i don't want this data to be loaded. So essentially, i want to know if there is some form of conditional compilation or something in asp (i know it technically shouldn't be called that, but i'm coming from a c++ background, so...) similar to the #if and #elif type directives in C
I can't place the code in a subprogram and selectively call it, because I want the arrays to be global so all my client-side scripts can access the data I'm using VBScript for the asp scripting.
View Replies
ADVERTISEMENT
I have a form with a list/menu where you select the year you were born. Now, when I submit this form, it creates a new register in my database etc.
How can I use a conditional to redirect a person that for example was born in 1987 or less?
if request.form("year")="1987" then%> is this the correct way to start?
View Replies
View Related
I have a ton of dynamic pages that I need an asp conditional to run on.I know the urls of all the pages and I want to know if there is an easy way to write a conditional statement that if they are on a specific page that it outputs something depending on the url they are on. Is there an easy way to do this?
View Replies
View Related
I have the following simple conditional on my page,
If EmpIDError <> 1 Then
'Show Input items
End If
Now I need to add another conditional to this,
If PosIDError <> 1 Then
'Show input items
End If
So I made it like this,
If EmpIDError <> 1 OR PosIDError <> 1 Then
But the problem is that if PosIDError = 1, then it still shows the input
items. But if I take the EmpIDError <> 1 out then it works with no
problems. Why would this be like this?
View Replies
View Related
I've got the following VB in an ASP page and can't see why it won't work
<% if Request.QueryString(Failed=="N")%> The Failed variable is N <% else
%>The failed variable is not N<% end if %>
I'm calling the page as thepage.asp?Failed=N
View Replies
View Related
I have written a small library for ASP, and I tried to keep it in a modular fashion, splitting my library in some files.
Then I have a file named "framework.asp" that include all the other files.
The problem is that I can't reuse code internally to my library because if for example:
framwork.asp include:
- utils.asp
-html.asp
Then html.asp include:
-utils.asp
If the programmer include framework.asp would have 2 times the same file utils.asp in his ASP page! Code:
View Replies
View Related
I have a code for executing a stored procedure and returning a recordset wrapped in an IF statement. If the statement is true the code executes. If the statement is false the code is skipped.
On the page, I want to display a message if the Recordset returned from the stored procedure is empty.
<% If rs.BOF or rs.EOF Then %>
Message
<% End If %>
Running the above code will return an error message if the recordset object doesn't exist...i.e. if the stored procedure hasn't executed and returned the recordset object.
How can I write the code to include that condition?
View Replies
View Related
Will this work in asp 3.0:
If True Then
<!-- #include file="test1.asp" -->
Else
<!-- #include file="test2.asp" -->
End If
View Replies
View Related
i have an simple invoice sheet and in "total" coloumn i need to put a formula like IF < 8.50 THEN VALUE =8.50.it is something like we dont do delivery less then 8.50 so if the TOTAL is less than 8.50 then it should turn in to 8.50 automatically.
View Replies
View Related
I have a shopping cart that I want to load items in that come from a huge scrolling form. In other words, when someone clicks on a category in our site, it scrolls out all the items in that category, maybe 30 or more. I have text boxes next to each item so somone can enter a number, then press submit form button at the bottom of the form, and
send those slections to the shopping cart.
The problem is, many of the text boxes are empty, yet they are still being sent to the shopping cart as a quatity of 0. Is there a way for sql to ignore a value if the variable is zero, or only get the sql statement to run if a variable is > 0?
View Replies
View Related
I am not too sure wats wrong w the if-else statement below!
<%if(grp==grp2)%>
{
<%if (start==req || end==req)%>
{
<%=grp%>
<%=start%>
<%=end%>
}
<%else%>
{
<%="There is no such record found"%>
}
}
<%else%>
{
<%="There is no such record found!"%>
}
<%endif%>
Error: 'else' without 'if'.
else
^
View Replies
View Related
displays content IF several conditions exist or display's nothing if it doesn't?
Basically, in english this is what I'm trying to do:
IF a record exists
WHERE session(userID) = idByUserID in 'notes'
AND
WHERE userID = idAboutUserID in 'notes'
THEN
display from the record fieldnames 'LastUpdate' and 'note'
ELSE
don't display anything
View Replies
View Related
I have a 'primary' intranet website and a 'secondary' backup of this site as
well. I would like to programmatically have the effect that if the
primary site is (page not found 404) not available, for it to access the
secondary site or at least be able to add a message with (or instead of) the
404 error dialog that the primary site is down and give the user a link to
the alternative (secondary) site.
View Replies
View Related
Ok I know this is simple but I cannot get it to work.
on the URL I have:
.../default.asp?strCode=xxx
I then have:
If Request.QueryString("strCode") = "xxx" Then
Response.Write "code is XXX"
End If
So for some reason it is not evaluating the queryString and does not enter into the conditional. Why?
View Replies
View Related
I'm trying to not show some data dependant on date but it never works right.
<% If Request.QueryString("EventDate") > DateAdd("d",6,Date()) Then %>
I have used similar routines before and it worked fine but this time i'm using a QueryString instead of a database field.
View Replies
View Related
URLURLI need help writiing an advanced conditional statement.I want to display an image if two recordset values = 1 or other various number combinations.
This statement works with one, how could I edit this statement to include two recordsets values? Say I want to add another feild say "recent" to this statement and it has a value of 2
Code:
<% if Recordset1.Fields.Item("progress").Value = 1 then ' Adv Conditional Region %>
<% end if ' Recordset1.Fields.Item("progress").Value = 1 %>
View Replies
View Related
The error code is:
Microsoft JScript compilation error '800a03ec'
Expected ';'
/bicc.nl/Connections/BICCwebsite.asp, line 2
Set Conn = Server.CreateObject("ADODB.Connection")
----^
The connectionstring I'm using: Code:
View Replies
View Related
Given a value in a database (Access) of type Currency how do I write a conditional statement such as the following:
if rs("price") > "$1,000,000" Then
Response.Write " Luxury Home"
End If
When I try this it writes out Luxury Home for every record, regardless of the value in Price.
View Replies
View Related
I'm just trying to figure out what the colon : does in this code:
<%If (Not isNull(COLOR)) Then If (COLOR = "Blue") Then Response.Write("SELECTED") : Response.Write("")
I thought it may be the ASP version of the Ternary operator, but it doesn't have the same effect. Is it just another way to concatenate? or a reverse concatenate?
or maybe a addition of an empty string to make sure that the output from the response.write statement is a string and not a number?
If the second response statement has a value then it prints it e.g. Code:
View Replies
View Related
Error:
*****
Microsoft VBScript compilation error '800a0400'
Expected statement
/HOD/MedHotels1.asp, line 89
End If
^
*****
Code: .....
View Replies
View Related
updating my asp page. here is the error code that i get, and on the bottom is my original code.
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
//shoppingcart.asp, line 19, column 70
set RSCustomers = Conn.Execute ("Select Max(Cust_ID) From Customers") As ("MaxID")
If IsEmpty (Session("Cust_ID")) Then
set RSCustomers = Conn.Execute ("Insert into Customers(Order_Date) " & "Values ('" & Now & "') ")
set RSCustomers = Conn.Execute ("Select Max(Cust_ID) From Customers") As ("MaxID")
Session("Cust_ID") = RSCustomers("MaxID")
End If
View Replies
View Related
I'm getting this error on opening a page from a category :
Microsoft VBScript compilation error '800a0411'
Name redefined
/includes/adovbs.inc, line 14
Const adOpenForwardOnly = 0
Generally what does it mean and how do I fix it?
View Replies
View Related
This is probably a simple question, but how does one format a table such that if a field is a certain value, then it will have a specific color.
For example, in the code below, if the specific field named "Year" is '2004' then I want it to appear in red, otherwise it should appear in black. Code:
View Replies
View Related
I have no idea what's wrong with the following ASP statement:
Response.Write "<select name="id">"
MS VBScript Compilation error 800a0401
expected end of statement
However, if I do the following, it will be fine:
<select name="id">
<%
%>
</select>
any ideas??
View Replies
View Related
I'm getting the following error on an ASP page that previously worked fine:
Microsoft VBScript compilation (0x800A03F6)
Expected 'End'
I know that this can mean that there's a problem with If..Then...Else structures, but I've checked them over & over and they appear fine. Same goes for loops.
I'm more than happy to send the code if necessary, it's just that it's rather long....
View Replies
View Related
why i got the error message using the following sql statement?Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
sql_update = "UPDATE Expenses SET Value = '" & val & "', Detail = '" & modifiednote & "', Time = '" & Time() "' WHERE myDate = '" & Date() & "'"
I am just trying to update my Expenses table in mdb database
and the table has field names:
1. MyDate
2. Value
3. Detail
4. Publisher
5. Time
View Replies
View Related
I need some help with my punctuation on this connection script: Code:
connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath((request.servervariables("URL"),1,InstrRev(LCase(request.servervariables("URL")),"installer")-1)) & "CPDatastore1.mdb;"
This results in this error:
Microsoft VBScript compilation error '800a03ee'
Expected ')'
where this punctuation need to go?
View Replies
View Related
I am attempting to connect a form in Dreamweaver MX 2004 to a Microsoft Access database and am receiving the following error message:
Error Type:
Microsoft VBScript compilation (0x800A0411)
Name redefined
C:DOCUMENTS AND SETTINGSLOOK FORWARDMY DOCUMENTSMY WEBSLOOKFORWARDV2.0DATABASES../Connections/conMembers.asp, line 8, column 5
Dim MM_conMembers_STRING
----^
From what I can gather the MM_conMembers_String has been used somewhere before in my page but I cannot figure out where. I have no knowledge of code and would great appreciate it if someone could help me out. In the attached file are both the conMembers.asp page and members.asp page code.
View Replies
View Related
Here's the error I get:
Microsoft VBScript compilation error '800a0400'
Expected statement
/Includes/Common/DebugFunctionsJS.asp, line 3
<script language="JScript" runat="server">
Here's the code:
View Replies
View Related
I am very new at this and ding this in context of a course. I am getting an error stating
Error Type:
Microsoft VBScript compilation (0x800A03EE)Expected ')'
Can you please look at this and tell me where I went wrong ? .........
View Replies
View Related
I have all of a sudden started to receive this error on my site!
I have no idea what script it is executing, why it is now failing, what is going on??
All I have been able to find out is that Microsoft has had the same problem on their site!
Microsoft VBScript compilation error '800a03f6'
Expected 'End'
?, line 0
View Replies
View Related
As you can see i am getting the following error message, this is for my university coursework j have finished the website but it just doesnt link to my databse properly
Microsoft JScript compilation error '800a03ec'
Expected ';'
/jamestoone/webbug.asp, line 2
Dim Conn Code:
View Replies
View Related
Here's the error:
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/SEI/test/order_step2.asp, line 1
Here is my code that I am using to write the cookie: ....
View Replies
View Related