If Table Doesn't Exist Give A Friendly Message
Just when I thought I was done , I try going to the "myfolder.asp" page and I get an error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
[MySQL][ODBC 3.51 Driver][mysqld-3.23.55-nt]Table 'streetguide.max' doesn't exist
/streetguide03/members/myfolder.asp, line 73
Line 73 is in red.
This is because the user didn't have a folder created, because they didn't save anything to their folder. On another page I have code that creates a table with the same name as the UserName, only if they decide to save something in their folder. Code:
View Replies
ADVERTISEMENT
I just wanted to know if anyone can tell me how can I give my website visitors the feature of "FRIENDLY PRINTING" through IE. Code:
View Replies
View Related
Is there a method where by I could check for a certain table or query
exist in my access database file before I made query to it??
View Replies
View Related
this runs perfectly as a .vbs but I'd like to convert it to an ASP... any
ideas? Code:
View Replies
View Related
I have been trying to submit a html form to an asp page. This results in 404 error. When i call a separate asp page with just a response.write or with a small text file i/o operation, it works fine.
But when i use a simple htm form with a text box and submit button gives a 404 error. All the pages exists. I use WinXP Pro/IIS 5.1.
Am i missing anything in settings? I tried restarting, reinstalling IIS and updating the patches to the latest but not of much help.
View Replies
View Related
tell me the syntax for adding string numbers together to give a total? Code:
strNumber1 = 4
strNumber2 = 2
strTotal = strNumber1 + strNumber2
The above code gives the result 4+2
If I change the strtotal to strNumber1 * strNumber2 it gives the result 8
If I change the strtotal to strNumber1 / strNumber2 it gives the result 2
If I change the strtotal to strNumber1 - strNumber2 it gives the result 2
So what do I use to get it to add the numbers together .
View Replies
View Related
how to give dependent listboxes in asp code.
View Replies
View Related
Please let me know how to avoid giving physical path & line number in the
error messages of web applications. Instead i would like to replace it with
general error message to the user.
View Replies
View Related
I am using CDONTS to send mail to the user from my ASP application.
However, the code doenst works all the time. I am able to get mails but
nothing happnes most of the time. The code works maybe once in 20 tries.
What could be the reason?
View Replies
View Related
I have a query in ASP that does a select * from table
It doesnt retun all columns!
When i use objRS("columnname") I get blank. This only effects some colums and I fix it by using
select *,missingcolumn1,missingcolumn2 from table
View Replies
View Related
i posted earlier, and the response seemed to be there is
another dll i need to use the cdonts object, i used it
fine for awhile on my old setup, i upgraded to 2k3 and it
errors up as if cdonts isnt an object. So is there a dll
i need to have to use the cdonts object in iis 6 or do i
need to rewrite my code to use cdo? (if so, please provide
asp 3 example on how to send an email with recepient,
sender, body and subject)
View Replies
View Related
I wrote the code for Members of Register. and i use cookie in this code, My database is SQL server. SQL server dosent support the cookies in my codes i dont know why this cause but my codes are working without any cause .
View Replies
View Related
I have got a problem wit da FILESYSTEM in ASP coding. Before I use window 98 installing PWS. Everything works fine....
And now, I use Window XP professional ( Laplop ), everything is updated ( Service Pack, .NET component, ASP.net stuff...
All my ASP code with FileSystem which used to be properly ran cant be executed on my XP server.
There is no message error on da page, but the browser icon keeps spinning and da content is blank, it means u dont see anything happens. I wanna ensure dat all da code is right, cos it work properly with PSW and other servers. I even tested with a simple code, but It still doesnt work..... Code:
View Replies
View Related
My ASP page contains the following VBScript code:
<%
zipCode = Request.Form("zip")
%> <br>zip: <%= zipCode %>, rf: <%= Request.Form("zip") %>
When I enter "abc" into the "zip" field on the form, I get the
following output:
zip: , rf: abc
Why doesn't the first statement assign the "abc" string to the
variable "zipCode"? What am I not seeing?
View Replies
View Related
My friedn is using PWS on NT4 machine, its a local machine, whenever he directs to an .asp page, visual interdev starts.
How can we over ocme this.I had solved this problem long time ago. Now i dont remember. Also to install IIS4.0 do we need to install MTS? if yes, where can we get
it?
View Replies
View Related
I'm using SQL Server and I decided to convert one of the fields from nvarchar to ntext. The transition in the manager was all right, but my ASP pages wouldn't display the ntext and there is no error message. I use Code:
<%=rs("Text")%>
to display the ntext...and there is nothing.
View Replies
View Related
I have a database table with several records. Now I am filtering some data based on the "where" statement. If I run the query in analyzer then I get 20 rows. If I run the same query in asp and assign GetRows() to an array, then the array returns only 4. I am not sure if I am using the GetRows wrong. Here is a snipp of my code:
View Replies
View Related
When we send a mail using the code below,we do not get simplified chinese characters if they are present in the body but we get junk in the mail and we need to change the mails encoding to simplified chinese to see the Chinese characters.
'CDONTS object
set objMail = Server.CreateObject("CDONTS.NewMail")
objMail.MailFormat = 0
objMail.SetLocaleIDs(65001)
objMail.From = sFromEmail
objMail.To = sToEmail
objMail.Subject = sSubject
objMail.Body = sMessage
objMail.Send
set objMail = Nothing
View Replies
View Related
I have one field char type data length 1.. It has data either 1 or 2 in all the field tht I have checked through enterprise manager.
I'm running query:
"select * from table" and fetching all the records and displaying...
It display all the data except data from this field..Doesnt display anything..
I had put Response.write rs("fieldname")
What could be the problem?
View Replies
View Related
For some of my pages I currently have part of the URL as being 'ourservices.asp?ID=1' (its got nothing to do with sessions) and I am currently changing part of it so its more SE-friendly - i.e. 'ourservices.asp?services=website-marketing'. However following Googles guidlines regarding dynamic URL's,. it says that some search engines don't crawl pages which have a '?' in them for fear of them being a session URL (which mine isn't).
My question is- is there any alternative that I can use to replace the '?' with another character for my dynamic URL. Or, is this the only way I can have this dynamic URL?
View Replies
View Related
Just looking for an affective and easy to use free 'Printer Friendly' script for an Intranet.
View Replies
View Related
can anyone tell me a user-friendly IDE for ASP? (not
asp.net). Is interdev has intellisense in it?
View Replies
View Related
I have an asp application that generate reports. The reports are a list of tables that contain information about users. each user has his own table. how do I get the tables to be printer friendly using either css or a script.And how do I page break the tables.
View Replies
View Related
has any one tried SE Friendly URLs with ASP & IIS? There's nothing like mod_rewrite for IIS. Ofcourse there are some 3rd party COM available but how many of us can use them on shared webservers?
So, is there a way to do it?
For those people who don't know what I'm talking about,
Normal URLs with querystrings look like
http://www.example.com/myPage.asp?id=1
while SE Friendly URL will look like
http://www.example.com/mPage/1/
The operative words being look like. You will see the 2nd URL in the browser's address bar but the server will take it as the 1st URL.
View Replies
View Related
I am trying to SEO a website which gets content from a CMS, and is coded using ASP, running under shared IIS hosting.
There are urls like http://www.example.com/search.asp?it...6&third_id=Red
To get some keywords in there, I was thinking how to get a URL like this
http://www.example.com/Widgets/Special/Red/search.asp OR
http://www.example.com/special-red-widgets.html
convert automatically into the one above with ? and ids..
If this can work, I can have keyword rich URLs, which when clicked can turn into old ID urls, and fetch relevant content from the CMS.
I've heard about IIS redirect but am not sure how it works. Considering that the site is on a shared hosting, I wanted to know your opinion and best ways to achieve this.
View Replies
View Related
I have developed a client based form using vbscript for a web page to run on IE and would like to make this form printer friendly. Anyone have some ideas?
View Replies
View Related
This message is being brought to you by a few of your friendly neighborhood ASP programming solution providers:
Please attempt to solve your own problems before posting to Sitepoint. I know I (and other persons who will remain anonymous) find it a little irritating when one (or more) of the following happens:
1) We can type your question into Google and the answer is the first hit that comes up.
1.1) We can type your question into Sitepoint's search and the answer is the first hit that comes up.
2) Your question is answered two posts below your question.
3) The answer requires merely looking up the appropriate object/function in the ASP/VBScript references. *
4) Two or three minutes after posting your question, you post "Oh, nevermind, I got it." without even referencing the solution so other people with the same question will know how you did it.
* Note that we will be VERY happy to provide you with links to these kinds of references (and indeed already have in the Important ASP Resources thread - which happens to be marked important twice) upon your request (I know of at least one individual who links these references in his signature also).
Now, please don't think that I'm ranting and raving. I'm just trying to inform those persons who do the above on a regular basis. It grows tiresome when I login for the day and all 5 new posts are questions that are easily answered with a simple link that could have been found if the one who posted the question would have spent 30 seconds researching his/her problem.
Mentors, Advisors, and Sitepoint Team Members:
If the opinions of this post are contrary to that of Sitepoint, please let us know. I would suspect that you would like us to spend our time on questions that are not easily answered instead of just repeating information which is already easily accessible.
View Replies
View Related
Just want to ask if anyone here has experience with doing printer friendly page. I have done a printer friendly page but the problem is if the line overflow, the printer friendly page will 'run' because my code count line by line, but by charactar or pixel.
View Replies
View Related
My application runs on ASP and the business logic is embedded in Dlls written in VB. The application hosts a list of articles for the user to view and these are accessible through some complex urls like "http://mysite/articles/category1?articleid=34512". I would like to denote a friendly url to these articles such as "http://mysite/articles/kb_TaxPlanning.asp". I am thinking of using an ISAPI filter to do the work for me. My friend was trying on using a httphandler, but it did not work. Please share with us the resources for creating an isapi filter for the same. Also how to use the same for the expected result?
View Replies
View Related
my data all can display.but when link it 2 printer friendly pages no data display
View Replies
View Related
Is there a way to get a printer friendly page using ASP. And when I say this I do not mean removing banner, picture etc and print the page.
The problem I face is, an ASP output is a big table with say 10-15 columns and it would not print even in landscape mode. So if I print the output from the IE browser the right side of the table gets cut. I want to know if there is an ASP code to over come this problem.
View Replies
View Related
What are the best approaches to create printer friendly pages in ASP web sites.? provide us help or links to useful artciles on this topic. Also can we avoid creating separate printer friendly pages and send the current page output to printer as the PRINT
button is clicked?
I have seen this functionality when we print our MCP transcript in MS certificastion site?
View Replies
View Related
I'm having problems finding a guide for search engine friendly URLs for ASP. I found some program for sale that needs to be installed into IIS, but this is no good. My web hosting provider would never allow this.
Can anyone point me to a helpful guide in creating search engine friendly URLs out of dynamic sites for a Windows server with ASP? If someone knows of any good hosting providers who already have the ISAPI_rewrite filter installed for its customers, that would be great also.
View Replies
View Related
