There is no error in the code but can't get output from this code;
<html>
<head>
<title>g</title>
</head>
<% set db=server.CreateObject("ADODB.Connection")
db.Provider="Microsoft.Jet.OLEDB.4.0"
db.open "C:/data/CIS_data.mdb"
VarQuery="SELECT FullName,ICNo FRoM Patient_Details"
set rs=db.Execute(VarQuery) %>
<% Do while NOT rs.EOF %>
<% rs.movenext %>
<% Loop %>
<% rs.close %>
</html>
</head>
Assume that there's a website named www.abc.com. There are 2 ASP files & one MS-Access database file in this site. The 1st ASP file is named "SearchForm.asp" & the 2nd ASP file is named "SearchResult.asp". "SearchForm.asp" houses a Form with a select list & 2 TextBoxes. The select list is populated from a MS-Access database table.
When the Form is submitted, the user is taken to "SearchResult.asp" which retrieves & displays the records that match the criteria that the user selected in the select list & the text they entered in the 2 TextBoxes in "SearchForm.asp".
Now the records that "SearchResult.asp" retrieves & displays - I want to display these records in a ASP file named "ShowData.asp" which exists in another website named www.xyz.com.
Is there any way by which I can display the records generated by www.abc.com/SearchResult.asp in www.xyz.com/ShowData.asp....
For a while I am working with ThumbsPlus ( http://www.cerious.com/ ) as manager for pics.
The benefit of the program is that it stores all kind of information in a central Microsoft Database that easily can be manipulated. A thumbnail of the picture is also stored in de MDB as long binary (jpeg format)
I made a small script that extracts all kind of information of the MDB by use of queries and ASP. This works perfect for string/numerical information.
I am wondering if I can also write the stored (jpg)thumbnail to the asp file so that I have a preview of my picture.
Can this be done? What is the syntax?
I tried already :
Response.BinaryWrite BinData
Where BinData is the contents of the Thumbnail field. When I take a look at the MDB table in design view, the DataType of this field is "OLE object", if I open the table, the contents of the field displays "long binary data".
For a while I am working with ThumbsPlus ( http://www.cerious.com/ ) as manager for pics.
The benefit of the program is that it stores all kind of information in a central Microsoft Database that easily can be manipulated. A thumbnail of the picture is also stored in de MDB as long binary (jpeg format)
I made a small script that extracts all kind of information of the MDB by use of queries and ASP. This works perfect for string/numerical information.
I am wondering if I can also write the stored (jpg)thumbnail to the asp file so that I have a preview of my picture.
Can this be done? What is the syntax?
I tried already:
Response.BinaryWrite BinData
Where BinData is the contents of the Thumbnail field. When I take a look at the MDB table in design view, the DataType of this field is "OLE object", if I open the table, the contents of the field displays "long binary data".....
How can I retrieve the output that has been sent to the client, e.g
[vbs]
<html>
<head><title>Test</title></head>
<body>
this is output
</body>
</html>
<%
Dim strContents
'Now I want to put the contents in an variable, something like
strContents = Response.Contents '(but that doesn't work)
%>
[/vbs]
With this line of command :
Response.ContentType = "application/vnd.ms-excel"
I can output a file in XLS format with no problem.
But on a specific server, the file pops as an ASP page. My code is fairly simple.
Does the server need to have Excel installed in order to work ??
How do I output an ASP variable insde of Javascript?
View Replies View RelatedThe problem i have in my system you can seacrh clients and then display their details. what i wanna do is find the client i want and then have a button called e.g. generate and then the asp pops up a word or rtf document with there details sloted in to a preformatted document.
Now i know i could do this by creating the doc line by line with asp on the file but is there a faster way of just inserting the asp values into placeholders in the word or rtf file which has already been setup?
I'm having a problem controlling the output from an access db and the css two column layout. It goes like this.Left side has a connection string and outputs 3 columns of db data to the leftside of the page. There is also a conection string on the right side of the page. It outputs that db data AFTER the right side processes that data. So the page is staggered, left to right instead of displaying the results across from each other.
View Replies View RelatedI have an ASP program. It outputs HTML with some
XML data islands in it. When I run the program, the
browser sees the HTML and doesn't work the way
I want it to. however, if I view source on the output
page, save the source as an XML file, then open the
saved file, it works properly.
How do I get the browser to treat the output from an
ASP program as XML instead of HTML?
How can I send gzipped (compressed) output back to the browser, using ASP (and IIS)?
I'm looking for a function similiar to PHP's ob_start("ob_gzhandler"); function.
This is really puzzling me; I am developing a site for a client and have uploaded it to a remote server with ASP enabled; I and my friends do not have a problem diplaying the output HTML from my ASP statements however, my client is unable to see it. He says he can see all the other page (CSS layout) but is unable to view the content (output HTML) from my ASP statement.
Now I am clever enough to know that ASP is server side, so I cannot understand why he can't see it- and he has tried this with two of his computers.
The only possible explanation that I can come up with is that he may have Javascript disabled in his browser as my pages contain a small amount of Javascript.
if guy can help how to output if my customer make reservation....enter everything ..etc enter first name, last name. then after click make reservation button it will come out his/her name on the page for his/her referrence ...then it will clear once another customer enter it.
View Replies View RelatedThis might sound stupid to you guys, ok i have this:
------------------------------------------------------------
perc = (total*100)/limit
response.write (" You are using ")
response.write perc
response.write (" % Of your 1GB")
-------------------------------------------------------------
but on the output i just need the first two digits, but i get this
You are using 21.8057899 % Of your 1GB
Please guide me. How can I output the records from my recordset in columns in a table? That is, instead of just one record per row in a table, how can I have multiple records per row?
View Replies View Relatedif something similar to php (ob_get_contents(), output
buffering) exists in ASP/VBscript.
I haven't being doing that much in ASP, but I have to create this:
It has to read out data from some DB to excel.
The following (corrected) code works if just it outputs as html, once
the Response.ContentType is excel. then it offers to open/save the
file, and stops - file not found - what do I do wrong? Code:
this question is not about SQL exactly
so, I am asking here.
how to get output from sql procedure ?
my sql p. like below
Code:
if not exists(select .....................)
set @result=0
else
set @result=1
so, how can I get @result in ASP
Does anyone know of any freely usable code that helps automate the
process of generating RTF files from ASP (particularly generating the
code needed for tables)?
I created an RSS script for my readers to use, but I have been having some minor issues with it.
Actuallyit works fine and I have tested it in 3 feed readers without a problem. Still it does not output as perfect XML if you go here you will see what I mean. Code:
GOT IT
SOLUTION= replace((date), "/", "")
how can i output todays date like this
11302006 ??
I am trying to build a knowledge base for use in out internal IT department. It uses SQL to store the data and at first just printing out the questions and answers in a table in plain text was great, but now I have run into a place where there needs to be links and line breaks and spacing. Formatting in general is going to be needed for anything with an answer over 1 line long.
It also needs to be able to be updated. I have the code working for the update right now, but I am not sure how to go about getting the ouput from the database to display where links are highlighted and such.
When the output is in excel format for an ASP page, some of the values displayed get transformed to decimal numbers instead of their true values. How to solve this problem? When the output is in plain html, the values are displayed correctly. Note that the values to be displayed are in TIME format. How can i change the format of excel cells in asp?
For output in excel when the form method is POST, no parameter values get posted to the other page. But when it is GET the values get posted. Y? I even change use request.querystring for GET but the result is the same.
I am sending a form to UPS and upon successful completion of the form, the UPS sends me a single output containing several variables and their values on the screen. I need to prevent it displaying on the screen, save it in a variable and then extract information I need and display those values with my format on a table. How can I do that. I heard in ColdFusion there is <CFHTTP> that does that. Is there equivalent of this in ASP.
View Replies View Relatedhow you parse " in asp. I know in php is it ". Also is a proper text output =("test") ?
View Replies View Relatedi m giving link print this article to my users to print the page.
Code:
<A HREF="javascript:window.print()">Print this article</A>
but it is printing whole window but i want to print only news part. i want to make the printed output "printer friendly". means stripped off the left and right side crap. And the banner ad at the top.
How do I get ASP to output text to a web page?
View Replies View RelatedI have a dynamic list that has a checkbox on each record. I am trying to set it up so that you can select as many records as you need and when you click submit it passes all the valus thur a URL par. I have it working now with just having the checkbox names all the same and then just passing request("checkboxname").
Only problem if there is more then one value it is auto putting a comma between the values. How do I edit that or keep those from coming up. is there a different way to do this ?
i need to create this in a loop, i'm not sure if it's possible, i need to create whats below,
1_1
1_2
2_1
2_2
3_1
3_2
so on
And where is the output sent to in a web app?
View Replies View RelatedI have a table of about 20 Categories. I currently have them displayed accross the page in a table from left to right in 3 columns. like this:
abuse cmecf credit/etc
dismissal presumptions
You will notice the sort runs from left to right. I would like the sort to run vertically like this:
abuse dismissal
cmecf presumptions
credit/etc
I am outputting from an access table into an html table via asp. Does anyone have a trick to get the output the way I want it. Could I populate an array and then output like this:
array(1) array(4) array(7)
array(2) array(5) array(8)
I am trying to change a current emailer script.
The current version will run a FOR loop for each form element and will give them a label (by a variable). This label is then attached to each form element's value on the email.
However the email is pretty untidy so I would like to change the code so that groups of labels appear as groups on the email.
I used this in my php:
header("Content-Disposition: attachment; filename="rhythmFile.js")
Could" someone please translate it into ASP.