I am trying to display a random background image for a webpage. I found this code to do it
<%
'Defines the number of background images you have
Const NUMBER_OF_IMAGES = 2
'Initiates the randomize function
Randomize
'Sets a variable: this will be used to hold the
'random generated value
Dim intImageNumber
'This is where we create the random number
intImageNumber = Int((NUMBER_OF_IMAGES * Rnd) + 1)
%>
Modify the body tag to accept the random number. In this case we are going
to place it within the image so as to facilitate the selection of a random
image. Code:
Right now i have multiple record sets. Im using the following Select statements: How can I combine ClaimNbrSQL, ClaimCovSQL, and ClaimantSQL to pull data based on ClaimdraftSQL.
They have different Where_parts because one field is not accounted for in the innerjoins for the the last 3 selects. Anyone know of a better way of doing this? The problem is the queried table is not matched up correctly. For example if there are 2 rows where dft_mirco_ecd_nbr are blank, the ClamiantSQL is off by 2 rows. Code:
I want to let users select one or more of my 5 choices in checkbox format, but also want to have a choice that is "all 5 choices". When "all 5 choices" is selected, I want to make sure they can't check any of the 5 choices. Is this possible?
May I know how to combine the text that get from textfield with the "strings" and insert it into database? Can anyone help me to check whether example below is correct or not. Any syntax error?
userid= request.form("userid")
emailaddress=userid + "@xxx.com"
insertsql= "insert into database(email) VALUES( '"&emailaddress&"')"
I have this code that will combine month day and year for some reason it puts the data in the database as January9,2005 February, 22,2005 . I need a space after the first month and I cannt figure out where the c
I'd like to combine if possible these two statements drawing from a total of 3 tables.
sql = "SELECT p.Sub_ID, p.Cat_ID, p.Sub_Name, COUNT(c.Sub_ID) as ct FROM Subs p LEFT JOIN Links c ON p.Sub_Id = c.Sub_Id GROUP BY p.Sub_ID, p.Cat_ID, p.Sub_Name ORDER BY p.Sub_Name"
sql = "select * from Subs inner join Cats on Cats.Cat_ID=Subs.Cat_ID ORDER BY Sub_Name"
Is it possible? Am I totaly screwed up for even trying? The goal is to count the relations ships in the Subs and Links table based on Sub_ID, to display needed data from the Subs table, and to display the Cat_name table from the Cats table in relationship to the Cat_ID in both the Cats and Subs Table.
I want to take the contents of many fields of various datatypes (varchars and text) and combine them into a single "junk" field that I will perform SQL Server free text searching upon, e.g.:
tblArticles Title Subtitle ArticleText
CombinedField [Title, Subtitle, and Article text smashed together]
Is it possible to create a query or T-SQL stored proc that would do this? Is SQL Server DTS a better approach? It needs to be built for each row in the table, and it needs to happen regularly.
Is it possible to recall a variable with the combination of text + rs.field? i want to recall the variable "speler1", at the place weher rs("speler") is 1. It's probably again easy.
I have several (three) CSV files each with different columns and dissimilar data. The only common column is transaction date. What I'd like to do is combine the data chronologically. I can't do a join query because the transaction dates do not line up from file to file and no other columns will match either.
I just want all the rows from the three different files put in chronological order in one place understanding that my columns wont line up since the source columns are different. I've exhausted every effort on the SQL side to combine these, but I'm thinking maybe there's a way to do it with FSO or something else.
It works fine but when I use this same code to get x characters plus display it using VBCRLF, with the <br> with writing the code :
<%=Replace LEFT (Recordset1.Fields.Item("Detail").Value,VbCrLf,"<br><br>",50)%>
it gives me error so please can you tell me how can i trim the characaters and at the same time use VBCRLF. why does this above code with LEFT + vbCrLF doesn't work.
I have several text files on my server and I would like to combine them into one text file by just appending each file to the end of the combo file. I know this should be possible, I just don't know how to approach it. Some combination of OpenTextFile and CreateTextFile?
and I'm trying to create a third variable that would strip the first letter of each of the above variables and combine them to create initials. Eg. if FirstName is John and LastName is Doe, the UserInitial variable would be "JD".
I am using asp to submit a form I've created in asp. I was wondering if there was a way to output the vlaues of three listbox menus.
1. User selects hour 2. user selects minute 3. user selects am/pm
This is now outputting into my strBody as seperate entries. I'd like to combine them into one entry within the strBody.
Please reference strStartTime, I've tried to incorporate this into the email strBody, but am unable to accomplish this. Any help would be appreciated. Thanks Everyone!!!
I've got a site managed in Frontpage and a forum in phpBB/MySQL. I'd like to grab the most recent posts from the Announcements Forum and embed them in the site's homepage. I got the idea from http://pocketpcthoughts.com/ . All of their homepage posts are fed from their FrontPage Archive Forums.
Right now, I'm using a phpBB mod called FetchAll to do the job. It works great except for one thing: I have to do it via an inline frame because I can't include a PHP file in an ASP page, and I have to use ASP because the site is in Frontpage (project requirement; FP is essential to the non-forum part of the site). Code:
the DoConnection sub is in another page called MyDBConnection in a folder call Common.
I know that I can use serverside includes and embed my con in the page using <%%> but I want the use runat server How can I make call to a function in an external page?
I want to put the same JS tag on sites A and B that call an asp page on domain C.
The tag would look like this: <script language="JavaScript1.1" src="http://secure.C.com/Demo/Intercept.asp"></script>
The ASP page on domain C would write a cookie, in theory the cookie should have permissions for read and writing from site C. Something like this: Response.Cookies("Name").Expires = Date() + 365 Response.Cookies(SurveyName).Domain = ".C.com" Response.Cookies(SurveyName).Path = "/"
In firefox the result is exactly as planned, a cookie is set when a user goes to sites A or B via site C, and using this same approach, I can read the cookie from domains A and B via the JS tag calling the script on site C.
IE does not like this. Sometimes it doesn't even write the cookie, other times the cookie has to be there b/c of resulting actions taken, but when viewing the list of cookies, it's no where to be found. Additionally, I don't seem to be able to read the cookie the same way as firefox is letting me.
I know this can be done, I went to foodnetwork.com (yeah I love to cook), and saw that they were using a metric service that was calling a back end script from the vendors domain, and setting a cookie from that vendors domain, all without the user seeing anything or leaving the foodnetwork.com domain. I've looked at the resulting JS code that is returned from these vendor back end pages, and it has nothing to do with the cookie being set, it's definitely happening server side.
i am trying to write a script to parse an external xml file, but am having problems... the problem i think has to do with me trying to do Response.Write(xmlDoc.transformNode(xslDoc)) before the xml is fully loaded. The link to the xml file is valid. Code:
I have multiple websites on my Intranet. My current search engines can search within their own environment. However, I would like to have one search page, which retreives results from all environments.
My first task is to connect, retreive and display results from a second server (through http). Then I will need to scrub the results to display in a unique template.
I have a site that pulls in XML data from an external third party and I need to parse it in my ASP page.
Could someone please suggest examples or online resources where I might learn how to do this? Everything I am Googling is confusing me with DTDs, XSLTs etc.
I'm looking for a way to include a file from another server in asp page.using #include won't work because it's not on the same server. In php, you can simply include(), and it doesn't care whether or not it's on the same server, is there a similar function in asp?
i have an asp page to list the result of search page.when i click on a link(href) , which is a 3D CAD file located in a directory ,it should be opened in a new page.This page shld support a 3D cad viewer in built in it.how to inbuild a CAD viewer in the HTML page?and view the link in that page
This Rs(k).value is a link to the 3D file (eg. "C:Directoryfile.dwg").When this file is clicked,the value of Rs(k).value has to be passed to the "prev.html" page and the file must be opened with "3D file viewer".How to inbuild the CAD viewer into my HTML page and how to pass the Rs(k).value to that page?
I want to load a web page from another server via http into an array or variable, parse it, and pull some data using plain ol ASP / VBScript.an example page to pull:
i need to create a site with a feed back system. one of my friend said to me ASP has nothing to do with this project. is it possible to do this using ASP ?if yes then what r the major functions that i should use.