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:
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?
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.
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..
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.
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?
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?
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.
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.
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?
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.
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?
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.
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
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?
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:
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:
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.
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.
