DB Field And Name Info
I 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.
View Replies
ADVERTISEMENT
I am using a Relational database for my site and i have the following tables:
FIXTURES, GAMEDATES
the fields in FIXTURES are:
GameDate
Home
Away
(All of the above are numerical fields)
the fields in GAMEDATES are:
DateID(integer)
GameDate(#Date Field#)
What i have done is in the GAMEDATE field in the FIXTURES table i have used the ID number of the date that i wish to assign to that record - using a LEFT JOIN to display the actual date that is pulled from the GAMEDATES table (That which corresponds to the relevant id used in Fixtures)
The problem is that in some of my code i want to display records using sql and sometimes in the where clause i use the following:
WHERE Fixtures.GameDate<=(Date())
obviously meaning WHERE GAMEDATE is LESS THAN or EQUAL to TODAY.
The thing is when i use the join it does not use the where clause and displays all of the records in the FIXTURES table.
Does any one know how to get around this, i have not received any error messages it just isnt displaying the right data
View Replies
View Related
Im comparing values in a field while doing a loop if sAct<>myData(5,i) then At the end of the loop I make the value of sAct equal the current myData
This will work when comparing other fields withing my recordset (so I know the statement works) but it will not work for the field I want to compare. The only difference with this field is that it has null values. Could this be the problem? if so, how do I deal with nulls?
View Replies
View Related
I have a input form with 5 fields. One of the fields is MajorNo and the other is named Description.
I have a reference table in my MS Access database (tblMajor)that lists the major numbers and their descriptions.
I would like to have the description field in my ASP automatically filled based on the major number entered on the form, so the user will only need to input the major number when submitting to the Access table (tblSalesTotal).
View Replies
View Related
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 Related
I 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 Related
In 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?
View Replies
View Related
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?
View Replies
View Related
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 Related
I 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.
View Replies
View Related
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.
View Replies
View Related
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).
View Replies
View Related
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
%>
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
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 Related
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 Related
Currently 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.
View Replies
View Related
How can I get ASP and IIS version info?
View Replies
View Related
When 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.
View Replies
View Related
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.
View Replies
View Related
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 Related
I 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?
View Replies
View Related
i have the users logging in from a database that part works. what i want to do is pull the users information from the data base to the page....
example
John Doe logs in pulls only john does info
marry logs in pull only marry info .
View Replies
View Related
if there is a way of verifying information that is in the registry of the user's computer? Or is there a way of checking if a file is on the c: of the user's computer??
I want to make a certain verification of who is entering my website.
but the IP address is never the same (since it is randomly given to the user) and I can't use the LOGON_USER variable because the users are not all in the same domain. And cookies are too easily destroyed with the IE options.
View Replies
View Related
I never had this happen. When i display my database into a table it displays fine. But if i change the order of the columns some of them won't display. No error codes at all.
i'm using a SQL DB with char, text and datetime fields. What can be wrong?
View Replies
View Related
Currently I have a list of products in a drop down list. not very informative or easy to browse.
browse to check4add.asp at http://www.flowersdirectory.co.uk
I want to be able to open a pop up where the customer can browse the additional products and pass the variable to the parent pages form variables.
View Replies
View Related
Can anyone tell me how to set my rates for billing? I have a reasonable amount of HTML experience along with Java and JavaScript but I don't know where I can find salary/rate information for ASP design work.
View Replies
View Related
i received info from a post method. i now need to resend these infos to another page
by post. how can i do it without having to create 54 hidden input ?
View Replies
View Related
anyone here got an idea how to create an upload page? or does anyone here knows a tutorial website regarding uploading using asp page?
View Replies
View Related
I am trying to learn how to retrieve information from the database. I am not too familiar with ASP but I was told to use it. How do I go about doing this? What specific aspect of ASP do I need to learn?
View Replies
View Related
I have it inserting a table into an iframe. However I want to pull that table information back out to make changes to it. I am just stumped on how I should go about it. I have the inserting of the table executing through a showmodedialog box. Do I do the same to pull out but how?
View Replies
View Related
I have .asp page that have a form. When form is submitted it's stored in Database.
How can I make it also send an email like to some spesific address when the form is submitted?
I already have .asp file that is some sort of a mailer and it works. But what should that button Submit have to pass parameters into that .asp and still continue what it would be doing?
View Replies
View Related