...selected value of select box.
...a select box.
I have a static array with 10 elements in it. I am trying to create an update form for a mysql database.
I want to get the info from the database to populate the field of the update form. My select box is populated by the array and I want the value that is stored in the database to be the "selected" element in the select box(= to array element). I hope this is making sense. Code:
how do i determine how many items are in an array? the following code creates an array of values each time a space is found in a name field. the problem is that sometimes names have middle initials and sometimes they do not. so i want to determine how many items exist in this array created bythe split BEFORE assigning values:
name_of_customer = Split(customer_name," ", -1, 1)
first_name = name_of_customer(0)
middle_initial = name_of_customer(1)
I have a database i want to be able to determine its size from an asp page, Also is it possible to list tables and column names list what tables are in the database and column names of each table contained?
View Replies View RelatedI need to compare the files in a folder to ones that are entered into a database (filenames list) and update it to include ones that dont have entities.
Whats the best way to accomplish this ? I'v thought of creating an array out of the physical file entities then rolling through the database and deleting the array entities that already exist; that way I end up with an array of filenames that need to be entered into the DB. that way just a thought (I wouldnt even know how to do it) but I want to think it through more thoroughly before starting the code:
I am trying to compare a date in my database to the current date. MySQL statement is:
sqltemp5="select * from users where dateclosed <= '" & date & "'"
What I am trying to accomplish is exclude records where the dateclosed field is older than todays date. Such as if dateclosed = 6/30/2004 then today being 08/25/2004 that record should be excluded.
I have a database of Company titles that I want to grab from an access
database, put into an asp array and then pass it to javascript so I can
output it into a CSS styled javascript menu. Right now I am stuck on
how to exactly put the database entries into an asp array. Below is
what I have so far.
So I want it to return distinct entries from the
Title field and put it into the array called Titles after the asp code
has done an HTMLEncode to make sure I can also pass it along to another
asp page. Basically I need to know what to put after the Do While NOT
Rs.EOF. Code:
What I need to do is to create a form of a dynamic size, and then save
everything from the form in a database. The number of forms depends on
a number from the database which I know how to get. I need to have a
comment and a number, for example if the number from queried from the
database is 2, then I need 2 forms, and it would be something like so:
Comment: Something
Number: 4
Comment: SomethingElse
Number: 6
When the user clicks the submit button, this would be saved in a
database in a table, in a new row. I have the database created and
inserting works very good when inserting just one row, but I need to
insert more then one row at a time, so it would be something like
this: Code:
I have the following code and nee to know how to make it return all records where sha is equal to any of the values in the array I have defined. Code:
View Replies View RelatedI need to populate an array with two columns of data from a database eg Firstname and second name and sorte alphabetically. So both of these columns go in to one array, I found this code.
View Replies View RelatedI have about 26 checkboxes that place all of my contacts into categories so in my database for contacts i have a field called categories that contains all of the categeories that each contact belongs to seperated by a ",". 1,5,17 etc.
I need help getting these values out of the database so that when I user select category 17 they get all of the contacts that containg the 17 in their respective categories field.
I have an array which I want to save into a database table I tried a few things but it doesn't work. This is as far as I got: Code:
View Replies View RelatedI am trying to write an array of random numbers to a database. The array part is working fine, but when I go to update the dataabse, it inserts the last value of the array into all the fields in the database .....
Dim MyValue,sqlRandom
Dim arrayRandom(8)
for i = 1 to 8
Randomize
MyValue = Int((100 * Rnd) + 1)
arrayRandom(i) = MyValue
response.write "<p> Array Value:" & arrayRandom(i)
sqlRandom = "UPDATE CarParkDetails SET FreeSpaces = '" & arrayRandom(i) & "'"
Conn.execute(sqlRandom)
next
I can't see whats wrong!
I have a DB that contains several columns named Line1, Line2, Line3, and Line4. After that I there are 50 columns named Data0 through Data49. Data0 and Data1 will always contain text but Data2 through Data49 may or may not be empty.
I am trying to take the values out of the database and put them into arrays. Since Line1 through Line4 never change I have no problem getting them into one array but I am lost on the logic/syntax on how to not only determine how many Data(n) cells are populated but then how to get them into a new array.
I have this dynamic array(shown below) that I need to match to values (1 - 10) that I am returning from the database via DSN connection object.
The values I need to match are on the same page (in their own table) but I am not sure how to match up the array indexes to these values. I want to be able to display the array result as part of or nested in another table. Code:
here is some background on the page I made. It's a calendar page with events listed. No database, just used id="" to display certain months depending on the option chosen from the jump down menu.
The question I have is this: I would like to display the current month's events when they land on the page. I used
<%
id=request.querystring("id")
%>
and created an <%elseif id="1" then%> and so on for each month. Is there a way can request the month and display that id? Thanks for you help. I have the code for the page if need be
Is there a way to determine the actual width and height of a image file ?
I'm using aspsmartupload to upload the image, how can determine and save the
width and height value ?
seems that aspsmartupload doesn't have this property.
If so, is there any method to determine it in asp in the simpliest way? I
will prefer to maintain the aspsmartupload method.
I have many servers which will be reghosted everyday with different OS
(Win2000, Win2003, WinXP...). How could I write the ASP code to get the
information of other servers' OS?
Let say the asp page is hosted on Server A, how can I check the OS version
of Server B and Server C?
How do you determine if a given date is a weekday (Mon-Thurs) or weekend (Fri - Sun)? Is there a built in function?
View Replies View RelatedSomewhere in my program I ask users to provide their website URL. I would like to determine if the given website exists or not.How can I determine a website with given URL exists?
View Replies View RelatedI am creating an ASP page for members of my team to add and delete records from specified tables. This table is choose by the user and I am dynamically creating text boxes. I also wish to include the type of the attribute to assist the user.
<%
for s_intCounter=0 to objRs.Fields.Count -1
%><tr>
<td width="34%"><% objRs.Fields.Item(s_intCounter) %>: <input type="text" id = <% objRs.Fields.Item(s_intCounter) %> > </td>
<td width="66%">Type: <% INSERT ASP FOR RETRIVING TYPE</td>
</tr>
<%next%>
I want to use asp to assign a css class to <td> tag. I was thinking an If statement, but i've not come across trying to assign a class to a table cell before! I want the cell background to be highlighted red determined by a database table with - yes or null. (null remains white, yes - red) At the moment it simple like this: Code:
<td><%=strAddress%> </td>
My web hosting account lets me use ASP and so I thought I'd try to learn and use some.
There is only one thing that I would like to know, and that is how to find out what version of ASP is running. Preferably, what I am looking for is something similar to the PHP php_info() function. Is there anything like this for ASP?
I have an ASP/ADO application querying an SQL Server DB. I want know the most efficient way to determine if more than one row is returned from a query. If more than one row is returned, the user will be presented with a choice of which row to process. If only one row is returned, I want to skip this stage, and process that single row immediately.
I can think of a number of ways of acheiving this (eg. .recordcount) but I'm looking for the slickest and most efficient method.
This may be a trivial question, but I was wondering how can you determine if a value contains an Integer or Float. I know there is a function called IsNumeric, however you can't determine what type it is.
View Replies View RelatedI built a simple scheduling application using an access db.
The relevent fields are eventRoom, startDate, startTime and endTime.
When I go to add a new event, what method can I use to make sure the
eventRoom is available for the selected date and time slot? Id like to just
display an alert with the conflicting times and suggest the next available
startTime.
I need to figure out if this file is over a day (or however many hours) and if it is, i need to delete it. If its not i redirect the user to it
Code:
If (fs.FileExists(workFile))=true Then
set f=fs.GetFile(workFile)
If (f.DateLastModified > Date-1)
Response.Redirect "/" & tFileName & "/" & reqString & ".html"
Else
f.Delete
End If
set f=nothing
End If
obviosuly the date-1 is wrong, i can't fid the appropriate syntax to save my life.
Anyone knows how to determine an image's dimension using Classic ASP?
Like How do I know the width, Height of this image using ASP?
Just wondering if anyone knows how to determine someones connection speed in asp the reason for this being so i can redirect the user to a different media file depending on their connection speed.
View Replies View RelatedI have a recordset with two three fields. One is an autonumber field called ID , one is a text field called Name and the last is a date/time field called DateEntered. How can I programatically determine the autonumber field ? Code:
View Replies View Relatedis there anyone here who can help me to determine google's pagerank with asp code. Just like pagerank tools are doing, where do they request data from, how do they get it, etc..
View Replies View RelatedIs there a way to determine the user operation system in vbscript and javascript?
View Replies View RelatedHow can I use the date() function in ASP with SQL statement.
I want to retrieve the records with today's date:
"SELECT * FROM Table WHERE [Date]=" & Date
where [Date] is an SQL Server datetime.
How do I separate the date from datetime so this statement can work properly.
First I would question why you want to do this. If they get to the page by any means it should respond appropriately, whether refresh or by link. This is a stateless environment after all.
That being said...
I would take the approach of setting a session variable that gets set the first time they hit the page:
<%
if session("NotTheFirstTime") = "" then
'write the onload
session("NotTheFirstTime") = true
end if
%>
then based on that variable write or don't write the onload.
Of course, if the user can access the page from multiple links and the onload is valid for each link, regardless of how many times they hit the page, this won't work....