I code that creates a calendar for each month and then it displays events from that month that are stored in a db. I need to loop through my recordset and display all the events, but I can't quite figure out how to do it. I am thinking I need to do an array. But I am not really sure.... any ideas. Here is where you can view the calendar. Code:
View RepliesI have an event calendar dynamically generated from the server's date and time. I have a database with events listed in it. What i need to do is to change the background color whenever there is an event.
I was trying to loop over the recordset and whenever the Date Number matched the calendar number it would change the background color of that table cell. how this could be done?
I've captured some data from a form and stored it in an SQL server table. The form is passed to an action script which builds the sql statement and writes the data to the db.
I want to write a URL (http://www.mysite.com/sites/home.asp)
and store the userID at the end of the URL (http://www.mysite.com/sites/home.asp?userID=22) so when I call the URL from a web page it goes to that users page.
I'm not sure how to approach this?
to keep things simple.. lets juz say i hav the following:
Code:
<%
dim i,j
dim region1(0)
region1(0) = 5
i=1
j=0
response.write (region&i&(j))
%>
the above output i got is 10.. so how do i the value of 5 printed instead
how can we declare a dynamic array in asp.say i have a counter name COUNT.how to i declare an array of size COUNT.its not DIM array(COUNT) cos it will give me a error.how is it done?
View Replies View RelatedI intend to have a dynamic array of non fixed size
set rsseats = conn.execute("select * from seats")
Dim arr(1)
response.write ubound(arr)
do while not rsseats.eof
ReDim arr(ubound(arr)+1)
rsseats.movenext
loop
set rsseats = nothing
But i will get hit with "The array is fixed or temp locked" how should i fix that
Does anyone know how to create a dynamic array? I need assign the values from database to the array one by one. I did a search and I can only find some complicated dynamicarray class. I am not to ASP and I have used other programming language. I thought a dynamic array shouldn't be that complicated.
View Replies View Relatedi need to create a dynamic form using xml
this is what i am doing
Response.Write "<ROOT>"
For Each Field In rstCampaign.Fields
If UCase(Field.name) <> "KEY" Then
Response.Write "<FIELDINFO><FIELD>" & UCase
(Field.name) & "</FIELD></FIELDINFO>"
End If
Next
Response.Write "</ROOT>"
in the browser i am getting just the field names.
the output i want should look like something
<?xml version="1.0"?>
-<ROOT>
-<FIELDINFO>
<FIELD>NAME</FIELD>
<FIELDINFO>
</ROOT>
WHAT DO I DO
I wrote a simple code to generate a dynamic array:
Dim TestArray2()
TestArray2=array()
Redim TestArray2(43)
When I uploaded this to IIS (on Vista Basic), the following error
message was given:
"An error occurred on the server when processing the URL. Please
contact the system administrator"
May I know what is the problem?
how do i create a array rs, not sure if the terminology is correct. but i don't want a obj rs i want a array.
View Replies View Relatedis there any way tohave an array where the first subscript is dynamic and the second subscript is static
View Replies View RelatedOk, given a string such as this -
203_2_0_0_1_5_0_234_0_8_22_2_0_3_345_2_3_0_0_0_9
Each three digit number in the string represents a unique ID of a file in a database. Following each ID are six digits, all seperated by a "_" . Each file will ALWAYS have six subsequent integers, such as above ID "234" has "_0_8_22_2_0_3_" following it.
What I am trying to figure out is given a string of any length of this specific pattern, how to decarle a multi dimensional array that would hold each ID and its corresponding digits.
To clarify a little further, this is from a shopping cart for a photographer. Each "ID" represents an image, each of the six corresponding numbers for each ID represents a qty for an image print size, ie., 4 4x6's, 5 5x7s, 0 8x10s, 1 16x20, 23 20x30's, 48 wallets. Oh, and the image ID's are not necessarily always going to be 3 digits, they could be of any lenght integer...
I want to save the details of a SQL search into an Array, Im dabbling and tryin the script below but i get an error Script:
SQL = "select item, number from table"
Set rsTarg = Conn.Execute(SQL)
i = 0
Dim TargArray()
Redim TargArray(i, 1)
do until rsTarg.eof
TargArray(i, 0) = rsTarg("item")
TargArray(i, 1) = rsTarg("number")
i = i + 1
Redim Preserve TargArray(i, 1)
rsTarg.movenext
loop
rsTarg.close
i = i -1
I would like to create a page of hyperlinks that are constructed from the contents of a database field. When the user clicks the link they are taken to a page that will display all fields from that particular record.
I already have the page structures in place. There are two pages, one with the links and the other to display the record. Code:
I've probably done this before, but for the life of me I can't remember how
I did it. I need to move values from a DB table into an array to be used
for other queries. The number of records will vary, so I need to make the
array dynamic. Can someone remind me how I can increment the index when I
write a new record? Code:
I have a little code to add multiple items to a shopping cart based
page. This code works perfect, but it adds all of the info to the
same input fields every time it loops. I need it to change the input
names each time it loops. Here is the code:
As the subject of this topic suggestions I am trying to find a way to
use ASP, SQL Server, Com+ and Crystal Reports 8.5 to Create Dynamic PDF
Reports Over The Web, but the only article I found that decribes this
process is located on ASPToday.com which is no longer an active
website. When I try and suscribe to the site I just get a message
saying to email, and when I email I don't recieve a response. Code:
Ok, I have a Javascript ASP and in it I have a dynamic repeating table with certain attributes to people. If one of these attributes is old or invalid, i want to change the color of the text (and maybe make it flash, blink, change size, something) so that it's easy to read.
View Replies View Relatedhow can I create a array of record
example:
I want to create a array of employees,and each array I have the name and age of the employee:
employees
+------------------------------------------+
|name: ze |name: ma |name: ro |name: car |
| age: 20 | age: 25 | age: 22 | age: 23 |
+------------------------------------------+
I want to create a new array called arrNames2 and copy contents of arrNames to arrNames2.
I then want to loop through my db and add more names (while going through the loop) to arrNames2. What is the best way to do this? Do I have to keep redim the array wehn I add more names?
how to create an array of checkboxes for a dynamic table. I want the checkboxes to display on the left of the table. When the checkbox is selected the user will select delete, edit, or update.
View Replies View RelatedI am trying to find distinct hostname. And my code is:
sql="select distinct a.Hostname, b.Productname from TableInventory as a, TableProduct as b, TableModel as c WHERE a.ModelId=c.Model AND c.ProductId=b.ProductId"
rs.open sql, cnn
After which im suppose to get the indivual hostname's productname, qty and cost.
i tried to split up the rs into array values Code:
Here's what I have:
quiz.asp?done=6|3|2
my asp code:
done = request.querystring("done")
Now, if I response.write done
I get 6|3|2
However, I want to create an array of 6|3|2 ???
I want to create textboxes dynamically but with dynamic names also.
i am retrieveing a load of values from a table in SQL into a DataReader.
Then i want to create textboxes from those variables. I want to dim various
textboxes with different names depending on what I retrieve from SQL. I
tried the following:
dim dtrcondet.item("contact_detail_description") as new textbox()
but this does not work
I am trying to create a site that has dynamic page generated based on if a value is present.
PROBLEM
I want to be able to show a certain dynamic page if a certain value equals to true. The page should be able to generate values from a db
e.g. <%=aspscript%>
And if the value equals to false, then the page should not appear at all.
I tried using SSI (Server side inlcudes) but cant append variable names to it or use them with if then statements
I would like to have some text appear in a different color if it matches a result in a database. I am not sure how the syntax would work, this is what I have come up with so far. Not sure how to insert it.
If <%=(Picks.Fields.Item("Pick1").Value)%> = <%=(Results.Fields.Item("Pick1").Value)%> then class="style1"
Is this possible? and if it is does it have to be entered for each occurance of the dynamic text or can it be added to css?
i want o make the images on my website depending on who is logged in. I have all of the Images names stored into my database, which i have uploaded there using the Pure ASP upload 2.09 add on for dreamweaver, and that all works fine and my image is stored in the correct folder and the name of that image is stored into the database as imagename.gif which is exactly what i want, but i dont know how i need to declare that value from the database into my style sheet. Code:
View Replies View RelatedI need to create a bunch of sites with slightly dynamic CSS. Basically,
all the image paths in the CSS need to be dynamic, depending on the
values of certain ASP variables.
I can think of 3 ways to do this:
1. Write a script to create a semi-dynamic CSS file, which will be run
whenever we need to make changes to the ASP variables controlling the
image paths.
2. Have an ASP script generate the CSS on the fly:
<link href="dynamiccss.asp" rel="stylesheet" type="text/css">
3. Put all static CSS in a normal CSS file, and have a special dynamic
style sheet for only those rules that require variability. We could
either use method 2 above to generate a second style sheet, or place
dynamic rules directly in the actual asp pages.
I have a form element and the name is dynamic
name="<%=cnum%>"
i now need to do this but it's telling me that it needs an to be a string.
JobsToUpdate = Split(request.QueryString(cnum),",")
and what would be ideal is the value of Jobstoupdate will be
This Cnum ->cnum=Split(request.QueryString("staticcnum"),",")
Hopefully I explained it well enough.
is there a way to make a dynamic dim, or am i looking at this all wrong
<%
Dim A & request.form("") & B
A & request.form("") & B = Request.form("")
%>
how to dynamically build an XML document with IIS6 and 404 error custom handler?
At the moment if I dinamically create an XML page with Response.Write(xml code here) I cannot remove header "404 errorpagepath" that IIS adds automatically. How to remove that header from Response object?
i think my code is correct.but it still can't work when i run in the nokia mobile browser,i had run my wap gateway and internet service server(ISS) also.
can anyone help me to solve this problem? The attaches file is the wml,asp and database for this program.
How can I create an array with no specified size. I tried to do the following with no luck
Dim my_array()
The code will be adding values to the array like this
my_array(i) = "First"
.
.
.
etc