Creating Clean, Retrievable XML Output
I would like to get a roadmap on learning from you folks. I need to learn
how to take an SQL view of data that I have and allow it's data to be
retrieved as an XML document in IIS.
I know how to create queries and views. I use Data Transformation Services
frequently (there isn't an XML document type in the OUTPUT options that I
can see) and, I actually get the concept of XML AUTO (for those who do not
know, this does a quick and dirty formatting of data in XML hierarchy), but
yet I do not know how to take these XML results and write them to a file,
allow it to retrieved (ONLY retrieved, not write back) from IIS as an XML
document type. Code:
View Replies
ADVERTISEMENT
I need to convert the Query Strings into Clean URLs, Found some articles on
PHP and Apache server.. How do we it them with ASP ??
View Replies
View Related
I would like to clean up my url's with a program like mod_rewrite in PHP. Is there anything out there that doesn't have to be installed to the server to do this job?
View Replies
View Related
I have always been in a habit of putting the process page separate from the original data input page. For Example my login.asp page will have the userid and password fields and then login_proc.asp page will process this information resulting in login/error message.
These days i am working with a designer company to upgrade our company web site and they are forcing me to put information and process information, 2 steps to be on the same page. The content will be conditional.
Now my question is, out of these 2 which is better way. The 2nd one is ok if the input page is really simple and same way processing of this information is simple too. But what if the input page is already receiving some parameters from other pages, and due to this, input information is already getting displayed conditionally.
View Replies
View Related
Is there any way to clean the user input before saving to the database.I tried to use..
Function StripNonNum(strInput)
Dim regEx
Set regEx = New RegExp
regEx.Pattern ="^[w-.]{1,}@([da-zA-Z-]{1,}.){1,}[da-zA-Z-]{2,3}$"
regEx.IgnoreCase = True
regEx.Global = True
StripNonNum = regEx.Replace(strInput, "")
End Function
But It doesn't work when user cut&paste the information to screen.For eg.Cut&Paste from a CV which contains Bullet points is there any way to remove these bullet Points before data saving..
View Replies
View Related
i am trying to clean up the messy .asp script that came with some new e-commerce software (Everest), as it gives far too much html. Take a look here.
I am going to take the java script out and reference it like this:
<script src="/superstore/productlist.js"></script>
<script src="/superstore/buy.js"></script>
(nicked from Tesco's website.. Hopefully it will work)
Can anyone suject how I get rid of all that messy creation of variables or Message strings?
WARNING! I am approaching this from a HTML point of view. Can do html in notepad and am working from the generated html files backwords to find out what the ASP files are, so please explain it like you are talking to a four year old.
View Replies
View Related
My site keeps going down and I don't know why. I've been looking for tips on cleaning up my ASP code but couldn't find any. Do any of you guys/girls have any tips on cleaning the code? What to do and what not to do?
View Replies
View Related
I have a 'textarea' javascript component which allows users to edit text in an HTML form's text area with some WYSIWYG features (such as emboldening, insertion of lists etc). However, this doesn't deal very well at all with text copied and pasted from Word.
Is there a way (a VBScript function maybe) which can strip out Word HTML upon submitting the form, or alternatively a good free text-area replacement tool with this built-in?
View Replies
View Related
i was wondering if there are any tools or programs out there that
can clean up your asp code like realign and make it more readable and
if there is can i have some recognitions please.
View Replies
View Related
I usually clean the session when the result page is presented to the user.
At this time, say an email confirmation was sent to the user and a pdf file
they can becdownloaded from the result page.
But if the user click the refresh or back button etc. for some reasons, they
pdf file is not available since it created on the fly when the request was
submitted.
So I am thinking about pull pdf file from database, but don't want the
database being hitted everytime the refresh button was clicked or the
requested is resubmitted.
View Replies
View Related
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]
View Replies
View Related
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 ??
View Replies
View Related
How do I output an ASP variable insde of Javascript?
View Replies
View Related
The 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?
View Replies
View Related
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 Related
I 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?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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 Related
This 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
View Replies
View Related
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 Related
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>
View Replies
View Related
if something similar to php (ob_get_contents(), output
buffering) exists in ASP/VBscript.
View Replies
View Related
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:
View Replies
View Related
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
View Replies
View Related
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)?
View Replies
View Related
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:
View Replies
View Related
GOT IT
SOLUTION= replace((date), "/", "")
how can i output todays date like this
11302006 ??
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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 Related
how you parse " in asp. I know in php is it ". Also is a proper text output =("test") ?
View Replies
View Related
i 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.
View Replies
View Related