How To Make A Dynamic Array
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
ADVERTISEMENT
Dynamic Calendar, Need To Create Dynamic Array....
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 Replies View RelatedMake Array Of Unique Numbers
For a simple search of a help desk application I've written, I'm querying text fields in two tables. One table is full of help desk calls (ids, where they're from, simple description, etc). The other table is full of messages that are related to a call (updates, reasons for closing, etc.) and has the call id as a foreign key.
I've got some sql queries setup to get a list of all call ids that match a search term. Is there a built in way to sort the results to make sure they're unique? I know I could do it manually in a few lines of code but am always looking for the easiest way.
Trying To Make Randomizer Script Dynamic
I have a random script I got online, and now I am trying to integrate it with a database, except I can only allow certain records to be random. Here is what i have so far, but I don't think it likes the RecordCount ...
<%
dim limit, random, rs
Call ReturnRecordset(killChars("SELECT * from quote where quotetype = Finance"), rs)
' Sets the upper limit for the random number
limit = rs.RecordCount
' Redim allows for arrays to be setup by passing a numeric value
' rather than hardcoding the numeric value for the limit multiple times
redim image (limit)
redim text (limit)
' List of images and links
Dim i
i = i + 1
While Not rs.EOF
image(i)="images/randomimage/testimonial-3.jpg"
text(i)= rs("quote") & " - " & rs("company")
rs.Movenext
Wend
' produces the randome number from 1 to the value of limit
randomize
random=int(rnd*limit)+1
'Writes the randomly selected hyperlink and image to the browser
%>
<p class="testimonial"><img src="<%= image(random) %>" border="0"></a><br />
<b style="font-size: 14px">What our Clients Say:</b><br /><br />
<%= text(random)%><br /><br />
<a href="finance-testimonials.asp?quoteID=<%=rsquote("quoteID")%>">Read Full Testimonial</a></p>
<%
rs.Close
set rs = Nothing
%>
What do you think?
I am getting this error message
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
How To Make Dynamic ASP Pages More Readable?
How do you guys make listings such as product listings and their detail pages more crawler friendly, if they are genrated using dynamic asp pages.
If your ASP uses a format like this: www.mysite.com/products.asp?idnum=3444 to display detail pages, how can I apply SEO to this format??
I know unix hosts use the mod rewrite, but I do not have access to the server settings etc. BUt I can access a database etc.
ASP/VBScript - Make My Dynamic Dropdown SORTable?
I have a page pulling some data from an MS Access DB, one of my columns is a "Application" column.
I have a dynamic dropdown pulling various Application names from a separate "Application" table in my DB. What I'd like to do now is to be able to select one specific Application from that dropdown and click the GO button to have it only show records with that Application name in them. Code:
Code To Make Dynamic Dropdown Boxes
I've been farting around with trying to make some dropdown boxes populate based on the value selected from the first drop down box..
I have 3 DropDowns..
1)PumpType
2)PumpMfg
3)PumpModel
the first one takes all the pump types from a database table called pumptypes and populates it
the second dropdown gets its values from an sql query to a second database table called pumpdata that puts all the manufacturers that have that have a pump that matches the type selected in the first dropdown.
the third box does essentially the same thing but looks for all the models based on the values of the first 2 dropdowns..
whats happening is when I select the pump type it goes to the next page without allowing me to select the other 2 boxes.
heres the code I have .....
Dynamic Array
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
Dynamic Array
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 RelatedDynamic Array
I 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
Dynamic Array
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 RelatedCreating Dynamic Array
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?
Dynamic Multidimensional Array
is there any way tohave an array where the first subscript is dynamic and the second subscript is static
View Replies View RelatedData From String To Dynamic Array
Ok, 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...
Multi-Dimentional Dynamic Array
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
Adding Index Number To A Dynamic Array
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:
Rebuilding Of An Array From An Existing Array
I dump the entire recordset into an array:
If not rs.EOF Then
aEmp = rs.GetRows()
Contents of the array are in this order:
EmpID,EmpName,Indent,Sub_ID,Lft,Rgt,MgrID, LastName
This query sort on the basis of Lft and Rgt columns.
The name of the array is: aEmp.
My question here is how can I get only the LastName from the aEmp array into another array so that I can sort the names alphabetically and then display the employees in the alphabetical order.
Or is there is another way I could this by using the same array while keeping the lft and rgt sort of the query? If I sort based at the SQL query level, I can see the names sorted by the lft, rgt and lastname, but since the lastname is at the end of the sort list - it does not appear alphabetically.
Array Integers Vs Array Variables
In working with arrays, I have found that I am unable to dimension and array
with a variable that has an integer value but I can redimension one this
way. I haven't see any information that tells me if this is a requirement,
although it appears to be because I get an error if I try it.
Ex.
Dim b
b = 10
Dim a(b) ' this errors out but
Dim a() ' this
Redim a(b) ' works
Code:
Make A DLL
How can I make a ASP-file to a .DLL? The idea is to protect the source from others who use the same IIS. Can I make a ASP-file that calls a .DLL - file with all functionality, or how does it work?
View Replies View RelatedCreate A New Array From An Array
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?
Make A Form
Hi does anybody know if you can make a form
have two actions and how?
How To Make 1000000 Looks Like 1,000,000 ?
how to format the table in order to show 23,567,987 instead of 23567987 , I mean it's very hard to read when there are more than 4 digits.
View Replies View RelatedMake Link
when you click on it to go to the off site the user name and password will be automaticly inserted to where the offsite is asking for the name and password.
My company deals with insurance companies and we would like to make it to where when our employees go to our intranet and click on a link to one of our carriers it will have the name and password in place for them. i heard its possible and old company did it but I am having so much trouble trying to figure this out.
How To Make OCX Talks To ASP
Its the first time I use ocx on my asp pages. Say I have an ocx which is a dropdown with multiple columns. Before its displayed, I call a method to populate the pulldown, so how do I make the script block talk to the html?
'script block
<%
dim myObject
set myObject=server.createObject("myObject.pulldown")
myObject.Populate(.....)
%>
'HTML block
<Html>
<OBJECT ID="MyObject1" CLASSID="CLSID:12345678-8AB4-4230-A65E-DA15A40F9900"></OBJECT>
Make Match
I want to know how to make a match for a text , for I'm wan't to search for this in the db . the search i made search only for the exact text user inserted so if the user misspelled the word the search will give him zero result. So i want to seach for any part of the word or if it is aword in aphrase.
View Replies View RelatedMake The Pop Up Info Box
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.
How To Make The Session
how to make the session timeout. and where should i put the session timeout.
View Replies View RelatedMake Support ASP
I have Windows 2000 Server. Running IIS 5. I created a ASP file that connects to a database and when i go to view it, It either says that there is a error in the code on like 106.
Which is only an "End If" command, Or it will say that this page needs to be posted on a web server that supports ASP. Well.. I have indexing service running, And I know for a fact that the code in the page is correct because it works on other 2000 server.
Make ASP Page
I have a webapp. that holds a lot of documents. Some of the documents needs to be produced from a database on-the-fly, some are static documents like PDF, Word documents, etc... In the end, a user can do a request to produce a large amount of documents as one huge PDF document. Today the creation of documents is working, but all code is done in ASP.
In Visual Basic, I was thinking about making an ActiveX EXE server that generates the PDF document. The ASP page will be polling until the file is generated. When this is done, the file will be displayed. I have only written down my thoughts on the subject. Is there a good way to do this?
Make Html Off
how to off the html in the textarea or text box. so if user write an html code in textbox or textarea , would.nt make the page changes. like this add thread how about if i wrote an html like </table>, it will make the display page change.
View Replies View RelatedIs It Possible To Make A Cookie NEVER Expire?
Is it possible to make a cookie NEVER expire? or not?
View Replies View RelatedHow To Make Checkboxes From Database
How to use asp to populate checkboxes from a column in an Access table? I want them to be updated when the table is updated.
View Replies View RelatedHow Do You Make If.then.else Do Two Stuff On One Line?
is it possible to do a insert, add, and a redirect all on the same page?
for example... signup.asp. there's a text box labeled Acctid. If you don't have an acctid please enter "0000" otherwise enter one. This box is used to see if they have an existing account in the database by using an UPDATE query and if they don't it does an INSERT query with acctid = 0000 for all non customers. What I want the if.then.else statement to do is to
If acctid = "0000" then
conn.execute acct_add
(and if sucessful to response.redirect "/yay.asp"
Else if NOT acctid = "0000" then
conn.execute acct_update
(but I want it to return an error if the update wasn't sucessful either because the acount doesn't exist or watever and if the update was sucessful to response.redirect "/yay.asp") END IF
Do ya get it?