aspfaq.com

Please wait for loading...




      (773):

    /
     2  +18 2014 aug 23email cdo html formatHow do I send e-mail in HTML format ? - Classic ASP 1.0 - Asp FAQIf you know of another mail object that supports HTML format , please let ... CONST cdoURL = "
     3  -1 2014 sep 17wrapped links in emailHow do I prevent my links from wrapping in an e- mail ?In most e- mail readers, this link will be active (clickable) but probably won't work correctly, because the mail program (and/or the mail server) ...
     3  ~ 2014 sep 14ial bookmarkingWhy can't I pass querystring information AND links to # bookmarks ?A workaround is to pass the bookmark as a querystring value, retrieve it and move to the bookmark using client-side script. For example, in your ...
     3  +2 2014 jul 27comments asp classicHow do I comment blocks of ASP code? - Classic ASP 1.0 - Asp FAQASP .NET 2.0 · Classic ASP 1.0 · COM / ActiveX Components ... Now, to execute the code again, simply comment the Sub and End Sub lines: ...
     3  +2 2014 jul 23asp remote urlHow do I read the contents of a remote web page? - Classic ASP 1.0Don't forget that if your remote page has relative image URLs , or style sheets, or JavaScript files, or frames, or links, it won't work perfectly when ...
     4  +2 2014 oct 02asp create arrayCan I create an array's size dynamically? - Classic ASP 1.0 - Asp FAQTo work around this, you need to declare the array without a size (or with a constant size, e.g. 0), ... Can I compact / repair an Access database from ASP code?
     4  +6 2014 sep 25asp datediffHow do I convert a DATEDIFF to days, hours, and ... - Classic ASP 1.0This isn't a very easy format to derive from traditional DATEDIFF calculations. I suppose you could calculate all three deltas individually, and take the mod of the  ...
     4  +5 2014 sep 05asp delay functionHow do I make my ASP page pause or 'sleep'? - Classic ASP 1.0Function WaitFor( SecDelay ,ShowMsg) ... timeEnd = timeStart + SecDelay ... Can I compact / repair an Access database from ASP code?
     4  +1 2014 aug 30creare tabelle access aspHow do I create a database from ASP ? - Classic ASP 1.0 - Asp FAQAccess Here is code that will create an empty Access database from ASP : ... This version allows you to create a database in Access . Note that ...
     4  +7 2014 aug 27asp file editor scriptWhich editor should I use for developing ASP applications?Crimson Editor supports syntax highlighting, multiple document interface, multi- level ..... Why do I get ASP 0113 / Script timed out errors?
     4  +15 2014 aug 19store image in databaseShould I store images in the database or the filesystem? - DatabasesI *strongly* recommend storing the file in the filesystem and its LOCATION in the database , though there are several components out there that ...
     5  -1 2014 sep 11asp uboundHow do I get all the UBound () values in a multi ... - Classic ASP 1.0The default element for lbound/ ubound values (these give the lowest and highest ... Can I dictate the load order of files on the client from ASP ?
     5  +47 2014 sep 10like sql serverHow do I search for special characters (e.g. %) in SQL Server ?There are several characters that have special meaning within a SQL query, for example the percent sign (%) in a LIKE query is a wildcard that essentially ...
     5  +9 2014 aug 25cdo html emailHow do I send e-mail in HTML format? - Classic ASP 1.0 - Asp FAQFor more information on sending HTML mail with CDO . ... the basic principle is that you create an HTML page that looks exactly like your e-mail .
     5  +2 2014 aug 18asp get urlHow do I get the name of the current URL / page? - Classic ASP 1.0To make that path local (for example, to use with FileSystemObject), just apply the server.mappath() method to the result. To get the entire URL , ...
     5  +3 2014 aug 17get url asp
     5  +1 2014 aug 09asp get current urlTo retrieve the name of the current file, you can use any of these: ... To get the entire URL , including the
     6  +7 2014 sep 21cint aspWhy do I get an 'overflow' error using CInt ? - Classic ASP 1.0Can I compact / repair an Access database from ASP code? Can I create an array's size ... Can I dictate the load order of files on the client from ASP ? Can I have ...
     6  +29 2014 sep 12subscript out of rangeWhy am I getting ' subscript out of range ' errors? - Classic ASP 1.0Subscript out of range usually means you tried to access an element of an array that was either greater than its ubound or lower than its lbound.
     6  -3 2014 sep 09load data sqlHow do I load text or csv file data into SQL Server? - Sql Server 2000If you need to load data into SQL Server (e.g. from log files, csv files, chat transcripts etc), then chances are, you're going to be making good friends with the ...
     6  +95 2014 sep 06asp padHow do I pad digits with leading zeros? - Classic ASP 1.0 - Asp FAQDoes order matter when using different languages in ASP ? How can I give them a better 404 message? How can I stop Photoshop from opening ASP files?
     6  +36 2014 aug 31sql server escape codesThere are several characters that have special meaning within a SQL query, for example ... Now, you might be wondering, how do I escape a square bracket?
     6  ~ 2014 jul 26database naming conventionsWhat naming convention should I use in my database ? - DatabasesHaving a poor naming convention can only add to the confusion, so it's important that you start with a good scheme, and think about what the ...
     6  -3 2014 jul 24find stored procedureHow do I find a stored procedure containing <text>? - DatabasesI see this question at least once a week. Usually, people are trying to find all the stored procedures that reference a specific object. While I think ...
     7  +38 2014 sep 08datediff asp
     7  +1 2014 aug 29url max sizeWhat is the limit on QueryString / GET / URL parameters?The spec for URL length does not dictate a minimum or maximum URL length , but implementation varies by browser. On Windows: Opera ...
     7  ~ 2014 aug 28asp html encodeHow do I decode an encoded URL? - Classic ASP 1.0 - Asp FAQThis question has been asked frequently (and variants of ' decode ' keep showing up in this ... How do I embed apostrophes (') and quotes (") in an HTML string?
     7  +1 2014 aug 11sql create temp tableShould I use a # temp table or a @table variable?A temporary table is created and populated on disk, in the system database .... Table variables are only allowed in SQL Server 2000+, with ...
     7  +9 2014 aug 07url character limitOn Windows: Opera supports ~4050 characters , IE 4.0+ supports ... is no limit on the number of parameters you can stuff into a URL , but only on ...
     7  +14 2014 jul 31classic asp text editorWhich editor should I use for developing ASP ... - Classic ASP 1.0However, I have not used it for editing " classic " ASP code. ... Basically a glorified text editor with a lot of features, such as tag completion, HTML ...
     7  +1 2014 jul 17mssql show databasesSchema: How do I list the databases on my server?The safest way to derive schema information from SQL Server is through system ... Shows how to use the Databases Collection in SQL-DMO
     8  -1 2014 sep 27provider error '80004005'80004005 , Microsoft OLE DB Provider for ODBC Driver Error Find a variety of reason that error 80004005 occurs.
     8  -2 2014 sep 24asp 500 errorWhy do I get a 500 Internal Server error for all ASP errors?This comes back to the user as a 500.100 Internal Server Error ( ASP 0147), and in certain scenarios a 404 Page cannot be found error , and doesn't leave the ...
     8  +93 2014 sep 15include aspHow do I dynamically include files? - Classic ASP 1.0 - Asp FAQOne of the greatest obstacles faced by ASP developers is the ability to dynamically include files. Since # include directives are processed ...
     8  ~ 2014 aug 27sql server betweenWhat are the main differences between Access and SQL Server ?This article will try to explain some of the differences between Access and SQL Server . It is not an exhaustive list, and in no means should be considered an ...
     8  +9 2014 aug 26asp validate email addressHow do I validate an e-mail address ? - Classic ASP 1.0 - Asp FAQYou can use ASP to validate the *format* of an e-mail address , but not necessarily that it is a valid and working ... Function isEmailValid( email )
     8  +3 2014 aug 20temporary table in sql
     8  -3 2014 aug 19sql temp tablesA common use of # temp tables is to summarize/compact/reorganize data .... Table variables are only allowed in SQL Server 2000+, with ...
     8  +1 2014 aug 11sql server temporary tables
     8  +1 2014 aug 10asp generate pdfHow do I generate PDF files from ASP ? - Classic ASP 1.0 - Asp FAQThere are several components out that there that will help you generate PDF files dynamically - whether based on simple ASP variables, ...
     8  +15 2014 aug 02convert to datetimeWhat are the valid styles for converting datetime to string? - DatabasesI wrote this little table and procedure to help me remember what style 112 did, or how to get HH:MM AM/PM out of a DATETIME column.
     8  +10 2014 jul 31send html email aspASP FAQ Tutorials :: Classic ASP 1.0 :: Email Scripts & Info :: How do I send ... alternate for non- HTML -aware: .TextBody = textbody . Send
     8  +93 2014 jul 24asp format dateCan I make VBScript format dates for me? - Classic ASP 1.0 - Asp FAQWell, VBScript's FormatDateTime leaves a lot to be desired. There really are only two ways to format a date by itself: VBLongDate and ...
     8  +13 2014 jul 21sql unix timeHow do I convert a SQL Server DATETIME value to a Unix timestamp?How do I convert a SQL Server DATETIME value to a Unix timestamp? ... then to determine what point in time that represents, you would run: ...
     9  +1 2014 sep 29%n in c by mircosoftWhy do some SQL strings have an ' N ' prefix? - Databases - Asp FAQThis denotes that the subsequent string is in Unicode (the N actually stands for National language ... SELECT * FROM a WHERE b LIKE @ c
     9  +8 2014 sep 16mssql convertMany people have asked how to convert a DATETIME value in SQL Server to a more familiar Unix-style timestamp. Well, the timestamp is merely an offset, ...
     9  +24 2014 aug 19asp stored procedureWhere can I get basic info about using stored procedures ? - Asp FAQAD Hoc Query exec stored procedure SQL Server, ASP - Calling Stored Procedure , Access ADO ODBC Sqlserver Stored Procedure , VBA ...
     9  +6 2014 aug 17create temporary tableA temporary table is created and populated on disk, in the system database tempdb — with a session-specific identifier packed onto the name, ...
     9  ~ 2014 aug 09temp table sqlThe data in this # temp table (in fact, the table itself) is visible only to the current .... Table variables are only allowed in SQL Server 2000+, with ...
     9  -1 2014 jul 19form submit new windowHow do I submit forms to a new window , with window.open() features?Many people have asked how they can submit a form to a new window . This is fairly trivial to accomplish; you can just set up your form tag like ...
     10  ~ 2014 sep 22vbscript dynamic arrayCan I create an array's size dynamically ? - Classic ASP 1.0 - Asp FAQVBScript's arrays have quite a few limitations. ... To work around this, you need to declare the array without a size (or with a constant size, e.g. 0), and then ...
     10  +91 2014 sep 08iis versionHow do I determine which version of IIS / ASP I'm running?If you are running Windows Server 2003, you are running IIS 6.0 / ASP 3.0 ( though ... you can determine which version of IIS / PWS you are running by one of the ...
     10  +28 2014 aug 18bulk insert csvIf you need to load data into SQL Server (e.g. from log files, csv files, chat transcripts etc), then ... The command to bulk insert this data would be: ...
     10  +64 2014 aug 12sql drop databaseHow do I drop a SQL Server database ? - Sql Server 2000 - Asp FAQCannot drop the database 'foo' because it is currently in use. ... However, this leaves out SQL Server 7.0 users, who don't have access to such ...
     10  +15 2014 aug 03add bookmark link asp<a href="default. asp # bookmark ?id=1">GO</a> OR ... client-side script. For example, in your link : ... Can I create an array's size dynamically?
     11  +3 2014 sep 17oledb acess violoationWhy do I get 80040E14 errors? - ASP FAQMicrosoft OLE DB Provider for SQL Server error '80040e14' Cannot insert the value ... Server error '80040e14' Syntax error or access violation  ...
     11  +21 2014 sep 16sqlserver convert
     11  +90 2014 aug 21csv to mssqlHow do I load text or csv file data into SQL Server ? - Sql Server 2000If you need to load data into SQL Server (e.g. from log files, csv files, chat transcripts etc), then chances are, you're going to be making good ...
     11  +90 2014 aug 16asp date yearASP .NET 2.0 · Classic ASP 1.0 · COM / ActiveX Components ... response.write YEAR ( Date ()) & _ ... response.write Pd(DAY( date ()),2) & _
     11  -6 2014 aug 14convert datetime to stringWhat are the valid styles for converting datetime to string ? - Databases
     11  -3 2014 jul 29ms sql trueHow do I handle BIT / BOOLEAN columns? - Databases - Asp FAQHow do I handle BIT / BOOLEAN columns? In Microsoft Access, you can say: SELECT columns FROM table WHERE boolColumn= TRUE -- or
     11  +49 2014 jul 17list table response sqlHow do I get a list of SQL Server tables and their row counts?To get an *approximate* count for all tables , you can use the following: ... DECLARE @ SQL VARCHAR(255) ... response .write "< table ><tr>" & _
     12  +1 2014 sep 19invalid procedure call or argumentWhy do I get ' Invalid procedure call or argument '? - Classic ASP 1.0This often happens because you used a VBScript "friendly name" constant in place of its integer equivalent. Visual Basic understands these friendly names, such ...
     12  +89 2014 aug 24csv to sql server
     12  ~ 2014 aug 23microsoft odbc driver80004005, Microsoft OLE DB Provider for ODBC Driver Error [ Microsoft ][ ODBC Microsoft Access Driver ] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively ...
     12  -2 2014 aug 19asp select boxHow do I retrieve the text and the value from a < SELECT > element?<form method=post action=page2. asp > ... based on the value, since the SELECT element does not support passing the text, only the value.
     12  +24 2014 aug 05asp response redirectWhat do I need to know about Response . Redirect ? - Classic ASP 1.0Note the code at the top of the page that does a " response . redirect ". .... So instead of doing response . redirect "page2. asp " you can simply ...
     13  +9 2014 sep 28sql server convert datetimeIF CHARINDEX(' SQL Server 2005', @@VERSION) > 0. INSERT ... 1, 02/22/06, CONVERT (CHAR(8), CURRENT_TIMESTAMP, 1). 2, 06.02.22 ...
     13  +12 2014 sep 14vbscript array
     13  ~ 2014 sep 08convert to sql
     13  +54 2014 sep 01asp request formRequest ("item") or Request . Form ("item")? - Classic ASP 1.0 - Asp FAQAccording to Microsoft, you should ALWAYS use the complete name of the collection you are retrieving items from. For more information, read ...
     13  +83 2014 jul 17what is bof htmlWhy do I get ' BOF or EOF' errors? - Classic ASP 1.0 - Asp FAQEither BOF or EOF is True, or the current record has been deleted; the ... How do I embed apostrophes (') and quotes (") in an HTML string?
     14  +11 2014 oct 04asp string containsHow do I make sure an entered string contains ... - Classic ASP 1.0Often you are relying on users to enter valid text for element names, file names, folders, etc. There is no "isValidFolderName()" function attached to the ...
     14  ~ 2014 sep 29upload file aspHow do I upload files from the client to the server? - Classic ASP 1.0To handle the uploaded file (s) from ASP , you typically need a component (some of these are free): ASPUpload · aspSmartUpload · ABCUpload · Dundas Upload
     14  +74 2014 sep 12asp encryptCan I perform simple encryption / decryption in ASP ? - Classic ASP 1.0In fact, it is more like encoding than encrypting ; it will protect the string from ... Can I compact / repair an Access database from ASP code?
     14  +45 2014 aug 18sql server concatenateHow do I concatenate strings from a column into a single row?This isn't exactly relational, and can certainly be handled by the presentation layer. However, there are kludges in SQL Server that will allow ...
     14  +87 2014 aug 15asp upload fileTo handle the uploaded file (s) from ASP , you typically need a component (some of these are free): ASPUpload · aspSmartUpload · ABCUpload
     14  +5 2014 aug 13sql server concatenate strings
     14  +24 2014 aug 02asp validation emailHow do I validate an e-mail address? - Classic ASP 1.0 - Asp FAQYou can use ASP to validate the *format* of an e-mail address, but not necessarily that it is a valid and working address. Here is a rather ...
     14  +12 2014 jul 24protect js filesHow do I protect my client-side JavaScript code? - Classic ASP 1.0'Hide' the script using a remote JS file , - the . js file is in your cache. Encode the ... PS: The mason jar trick works well to protect your .GIF files ...
     15  +6 2014 oct 03send html format emailHow do I send e- mail in HTML format ? - Classic ASP 1.0 - Asp FAQYou should make sure that your content is easy enough to read for those that have disabled HTML , are using a web interface that doesn't allow HTML through,  ...
     15  +19 2014 oct 02import csv into sqlIf you need to load data into SQL Server (e.g. from log files, csv files, chat ... You can specify row and column delimiters, making it easy to import files in ...
     15  +5 2014 sep 25asp servervariablesWhat is wrong with Request. ServerVariables ("HTTP_REFERER")?The situations where this ServerVariable works include the following methods of a browser loading a ... <form method=POST action=ref. asp name=postform>
     15  +15 2014 sep 25asp trimCan I mimic trim / ltrim / rtrim in JScript? - Classic ASP 1.0 - Asp FAQWhile the HTML might look like it trimmed too much in the first two cases, if you view the *source* of the output, you will see that all of the spaces are intact.
     15  +86 2014 sep 21sql arrayHow do I simulate an array inside a stored procedure? - DatabasesOften you will want to pass an array to a stored procedure and have the procedure loop through and process each element in the array . Unfortunately, T- SQL  ...
     15  +2 2014 aug 25max url length
     15  +29 2014 aug 21asp classic image uploaderASP .NET 2.0 · Classic ASP 1.0 · COM / ActiveX Components · Forms ... For your users to upload files, you must provide them with the following interface: ... How do I pass x-y coordinates to ASP , after the user clicks an image ?
     15  +45 2014 aug 15protect javascript codeHow do I protect my client-side JavaScript code ? - Classic ASP 1.0PS: The mason jar trick works well to protect your . ... After many attempts at hiding my JavaScript code , I was thwarted every single time - by ...
     15  +42 2014 jul 28free asp with ftpHow do I FTP files from ASP ? - Classic ASP 1.0 - Asp FAQetiveFTP · PowerTCP FTP ... FTP via ASP without using 3rd-party comp... Note that .... Where can I host ASP pages for free (or at least cheap)?
     15  +8 2014 jul 20asp date convertHow do I convert local time to UTC (GMT) time? - Classic ASP 1.0Many people have asked how they can convert local times to UTC ... These examples will show how to find GMT time for another date *in 2001* ...
     16  -4 2014 sep 25sql server if existsHow do I determine if a table exists in a SQL Server database?For normal tables, you can use this query ( SQL Server 2000): ... of the way, here is how you can use the OBJECT_ID function to determine if a #temp table exists :  ...
     16  -3 2014 sep 16asp serverSQL Server , ASP , Technical ArticlesFAQ on ASP from Microsoft ASP newsgroups. By Aaron Bertrand and Jay McVinney.
     16  +17 2014 sep 16sql where likeHow do I search for special characters (e.g. %) in SQL Server?
     16  +74 2014 sep 15error 400 bad requestWhy do I get HTTP/1.1 400 Bad Request errors ? - Classic ASP 1.0HTTP Error 400 400 Bad Request Due to malformed syntax, the request could not be understood by the server. The client should not repeat the request without  ...
     16  +8 2014 sep 09seinding text classic aspFrom ASP Okay, enough chatter, here's some code that will help you construct ... you'll quickly find that it doesn't support sending formats other than plain text .
     16  +85 2014 sep 02sql server import csv
     16  ~ 2014 aug 28check if cookies enabledHow do I detect ENABLED cookies / javascript? - Classic ASP 1.0There are several components which will allow you to determine if cookies or javascript are SUPPORTED. You can even do it yourself, with ...
     16  +85 2014 aug 15asp file upload form< form method=POST name=form1 action=handler. asp ... To handle the uploaded file (s) from ASP , you typically need a component (some of ...
     16  +21 2014 jul 28asp session timeoutHow do I increase timeout values? - Classic ASP 1.0 - Asp FAQThis value indicates how long, in seconds, the server will let an ASP script run ... You can increase the session timeout in an ASP page or in ...
    1 2 of 8 pages