I have set up a table of Ticket Types. Most of these only have a ticket number but one type also has a reference number.
I am trying to display the info in a table and show the ticket number for every type and only show the Ref number when it is applicable.
I'm guessing its a FOR ELSE statement but I can't get it working. Code:
i am new to asp and web designing, and was wondering how to reload a page so that a different set of images appear, depending on which submit button is pressed. Code:
View Replies View Relatedi am creating a kind of search using dropdown boxes to search the database. I have got two dropdown boxes one called location and one called cuisine i have sorted out some if statement.
so that it works if they select either one or the other and if they select any location or any cuisine but the problem comes when i need them to be able to select a cuisine in a particular location ie on bothe boxes.
i need it if both are selected at the same time then search the database via location and cuisine. can anybody help here is the code for the two files.
if Line = "" OR NOT IsNumeric(Line) Then
error_list.add"589344","desired line must be specified"
b_error = true
End If
how i can display an error msg saying that the user must only key in number but not character
i have got one field in sql server 2000 database. field1 char 50 in one record, i m storing value -1 but it doesnt satisfy following condition
if (rs("field1")) = cstr("-1") Then
response.write ("true")
end if
i already checked its value by response.write and
print -1 only..
then y its above condition is false?
I WAS having problems. Solved it myself. I'll edit to show the working query for those who could use an example...
I'm having a multiple condition problem in my query statement. I know the what the result should be, but I have something wrong...
Here's the query:
set GetNADs = server.CreateObject("ADODB.Recordset")
set GetNADs.ActiveConnection = adoConnection ......
what s the correct syntax of setting a condition with a variable that is retrieved from database like in the example below:
dim x
x = 9
if rsTypes("one") = x then
response.write ("error")
I'm trying to make a very simple condition about some variable if it is empty do something but my problem is that it always cannot see it is empty
i mean i have a field in a table called title and this field is some times empty
so i need to type "empty" if it is
i tried this code ....
I want to check a another field and if its got info in it i want it to do the then bit, if the field thats checked has no info then its off to else
can some one give me a quick hand on what it should look like?
<%If Your_Condition_Here Then
Response.Write("<form ACTION=""=MM_editAction"" METHOD=""POST'""name=""form1"">")
Response.Write("<input type=""text"" name=""textfield"" value=""(tpwimportrs.Fields.Item(""comments"").Value)"">")
Response.Write("<input type=""hidden"" name=""MM_update"" value=""form1""><input type=""hidden"" name=""MM_recordId"" value=""tpwimportrs.Fields.Item(""ID"").Value "">")
Repsonse.Write("</form>")
Else
' Do Nothing
End If%>
I want to search through different strings and replace the ‘0’ with empty value. My problem is I want to search and replace the ‘0’ with empty values until there is a value other then ‘0’.
Examples
Ex 1: 000010000 - > my desired output -> 10000
Ex 2: 000170000 - > my desired output -> 170000
Ex 3: 004001000 - > my desired output -> 4001000
I've got the following code that sets a session object.
set obj = server.createobject("Scripting.Dictionary")
set session("testobj") = obj
If I want to remove the session object, do each of the following does
the same job? Which one is the best?
1 --> set session("testobj") = null
2 --> set session("testobj") = nothing
3 --> Session.Contents.Remove("testobj")
If I want to check if the session object is not exist, which is the
best option?
1 --> if (session("testobj") = null) then ...
2 --> if (session("testobj") = nothing) then ...
3 --> if (isobject(session("testobj"))) then ...
I want to change the font colour to red if a recordset value is 'high' but i dont know where to put the font tags, Heres what i got so far:
<td width="13%" align="center"><% if rs("priority") = "High" then response.write rs("priority")
else response.write rs("priority") %></td>
But where would i put the font tag and the colour, so it coloured the priorities marked as high red?
I am trying to update and append to an existing XML file. However I seem to be stuck. I am using ASP as my scripting language.
The form fields has the same value as the KEY attribute so all i have to do is loop through the submiting form for its fields and use the name to update the XML via the keys... Code:
Is asp.net similar to vb.net ? What can you create with it ? ,Is there a program you suggest me to use , or even a compiler ?
View Replies View RelatedI need to know where I can get information about learning how to code in ASP. This getting cide snippets and such doesn't work out real well if you don't know what to configure. Also I would like to have my own work not someone elses.
View Replies View RelatedIn different examples I've seen different ways to do the same thing, and I want to know what is best (fastest, easiest to remember, same command for all types of stuff, etc)
For example, to get data from a database, should I use:
[VBS]set rs = conn.execute sqlstmt[/VBS]
or
[VBS]rs.Open sqlstmt, conn[/VBS]
or something else?
what can i use to get my server's ASP information, like with PHP you can use:
PHP Code:
<? phpinfo(); ?>
What can i use in ASP?
I have a form that I use a few option selections from DB table and a insert script at the end.I'd like to have access to aditional info from the same table after choose an option
View Replies View RelatedI am trying to retrieve data from a dropdown listbox in asp using:
<%Response.Write + Request.Form("cboBox")%>
The problem is that I only retrieve the first value of the option. For
example, if my first option was <option value=this that>, I only can
retrieve "this". It won't get the second word.
Recently, I came across a site with information to my area of knowledge. The pages have been designed and consist of the .asp extension in the url.
I'm not able to select the text on the web page, either click right mouse button or anything to copy the information. when I'm trying to print it is not perfect.
So, I would like to know from ASP guru's whether there is any way of saving the information on the web pages, so that the same can be formatted in a word document for printing purpose.
My web site is windows authenticated.
When someone connect to my site, I get his SID with a small active X object
which uses OpenProcessToken and GetTokenInformation (token user etc ...
But now, I also need the SID list from AD user object SIDHistory. (when a
user is moved across domain).
I've got a WYSIWYG editor, that runs off a template page (i.e. template.htm) that gets opened in an iFrame for editing.
How can I get it setup so I cange the template at the click of a button? I've tried doing a form with radio buttons, but can't get it to work.
For example, the iframe source has been set to "strTemplate". My form processing was along the lines of:
<%
If request.form "template" = "template1" then
strTemplate = "template1.htm"
Else
strTemplate = "template.htm"
If request.form "template" = "template2" then
strTemplate = "template2.htm"
Else
strTemplate = "template.htm"
End If
End If
%>
Anyone have anything like this? I don't care what data it is... I just want
to see how to query the AD and place the data into a web page.
Basically I want to be able to send users (if they sign up to it) an SMS alert whenever someone leaves them a message on a webpage. Similar to Hotmail where you can get an SMS when you receive an email, or Ebay where you can get alerts if you are outbid.
I'm thinking maybe something very similar to CDO in terms of coding Code:
im running an asp page where by i can upload a xls file- which adds data to a database provided it passed validation. this then sends a success message to the user. what i need is a button where i can call the data which was recently added into the database- but dont know how to go about it or code.
View Replies View RelatedI am using :
<% FOR EACH field IN size_info.FIELDS
Response.write("<option value=''>" & replace(field.name, "asize", "") & "</option>")
NEXT%>
to loop the names of the fields in a DB, but I cannot get it so that is the value of the data in that field is lower than 5 it simply doesn't show, i thought i might be this
<% FOR EACH field IN size_info.FIELDS
if size_info.fields.name.value > 0 then
Response.write("<option value=''>" & replace(field.name, "asize", "") & "</option>")
end if
NEXT%>
but that doesn't work.
Is this the right forum for this. Considering using this but not sure, specially considering the price and I would need to add a host. If you have any knowledge please let me know. Also if this the right forum, also let me know and I will give more details. It is an ASP program of course.
View Replies View RelatedCurrently I have one asp page which opens after the proper ID entered by user and it generate <A> tag with application software download link. When the user click on the link (which is pointed to the actual physical file.EXE of Size around 10 - 20 MB) it downloads file. But how do i change the logic so that the activity will get LOG in some text file. Like which user has downloaded which file. (it should log into text file).
I think I need to remove the <A> for direct download instead it shoudl call an asp page whcih should log the event and push the file to user.suggest with sample code if possible.
How can I get ASP and IIS version info?
View Replies View RelatedWhen you hover over one of the topic in this forum a box appear with the first few lines of the message in it. How is this created. What events area used to creat something similar and does anyone know of any good website where i can look at a tutorial for it.
I dont even know what they are called so dont know what to search for even on the web as if i write pop up i get something else which i dont think is what i really want to use, or maybe it is.
I am working on a users system for my site. I have the databases and most of the pages set up. But, I need to create a page called "My Info". This page would display only the information of the person that is logged in.
I am curious as to how I would retrieve only one entry in an access database and display it based on the person logged in.
anyone know how to update the inforation in a select box without refreshing the page or using massive javascript arrays using regular asp(not .net)?
View Replies View RelatedI have an intranet site hosted in IIS 5.0 Win2000, and want to display the name of the user logged into the local machines(WinXP) in the pages they access like 'Welcome JohniBravo'.
So, i used the Request.ServerVariables("LOGON_USER"), but get a blank ("") displayed in the page. And i even tried "REMOTE_USER" but, still the same. from somewhere i got to know that theres something called 'Allow anonymous user' should be enabled to get these info from servers. help me with the same?