These FAQ's are all about Server-Side Scripting and Web Applications. Server-Side Programming describes any code/software/scripts that are executed by the web server.
Looking for a chance to boost the design, layout and functionality of your website within a few clicks? This category contains CSS and DHTML FAQ's. Furthermore there are some great extensions to ...
These FAQ's are all about SQL and Databases.
Do you have Questions about Dreamweaver? If so, please check out this category.
Are you looking for an FAQ that isn't listed in the categories above? Please check out this category.

Explore the FAQs

ASP

Delete Dynamically Named Folder

Question:


How can I delete a dynamically named folder with the record it belongs to? 
I created a member site that uses Pure ASP Upload to create a dynamically named folder for each member's images when they first upload. Sometimes we need to delete a member and want to delete the folder as well. Not all members upload images so not all members have folders. How can I delete the folders with the deleted record and insure the page doesn't crash when there is no folder? Read More
Basics

Blue line around images

Why do I get a thick blue line around images when I insert them into dreamweaver? It does not happen all the time and it shows when I preview the page in the browser. Read More
SBB Controls

How do I change the language of a FullText catalog?

Question:



How do I change the language of a FullText catalog in SQL server ? Read More
ASP

How do I reset the Autonumber to Zero in MSSQL

Question:


You have designed your database and populated it with test data and it is all working fine. It is time to go live and you delete the test data and are ready to go live.

You go live and when you see the live data going into your database the live auto number (@@IDENTITY) starts at the end of the last test number.

No Panic... just use the following in Query Analyzer

Read More
ASP

How do I handle BLOB fields in the Recordset

Question:


When dealing with BLOB fields from Microsoft SQL Server, you must put them to the right of non-BLOB columns in the resultset. To be safe, you should also read the columns in left-to-right order, so if you have two BLOB columns as the last two columns in your resultset, read the first one and then the second. Do not read them in the reverse order. Read More
Browser Issues

Typed URLs Do Not Go Away

When use the "Clear History" option in Internet Explorer 6.0, the URLs typed during that sesion go away, but there are a couple of URLs that remain.  Those two URLs also show up whenever I type the first letter of them,  but they do not appear in the windows registry when I try the following:

  1. Click on Start, Run
  2. Type REGEDIT
  3. Navigate to the following 2 keys by clicking on the little plus signs (in the left hand pane) HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\TypedURLs   HKEY_USERS\.Default\Software\Microsoft\Internet Explorer\TypedURLs
  4. Delete whatever string contains the URL you want to erase.

I am wondering from where Windows is getting those two old typed URLs.

Read More
Browser Issues

Internet Explorer Clear History Does Not Work

When I select "Tools|Internet Options|Clear History" in Internet Explorer 6.0, I still have the sites visited in the History Pane. Read More
Stored Procedures

Create a random number and Insert it into a DB field

How to create a random number and insert it into a database field along with information fom you web form.

Read More
Netscape

Borders in Netscape 4.75

How to set background image in a table of 1 row and 1 column if that table contains another table which has mXn rows and columns

Also If u take a table with cell padding and/or cell spacing not equal to zero then Netscape put some colour in the border of the table

Read More
Error Handling

Using the File System Object on IIS with Norton Antivirus Running

When using the FSO, my ASP page tends to "hang", but doesn't report any errors.

For instance if you use the Pure ASP upload Pack by George Petrov

Read More
Dreamweaver

Disable button when none selected

Q:

How can i disable a button within a form untill a selection is made, for example when using a poll form ?

Read More
Databases

Is there an easy way to create a DSN-less connection to a database?

Steps to Create a DSN-Less Connection String for your Access and SQL Server database(s) using some nice windows features.

Read More
Dreamweaver

FrontPage & Dreamweaver Problem

Since I installed Dreamweaver 4, FrontPage 2000 has not opened properly. Read More
PHP

Username Session variable KT_Username(MM_Username)

Using the stock phakt code I couldn't request the session variable KT_Username on subsequent pages, this shows you the easy fix. Read More
Browser Issues

No framepage escape from frameset

How can I prevent a framepage from being viewed outside of its frameset ?

Read More
ASP

How many results at one page?

This FAQ explains how you can have your visitors decide how many records they want to be displayed in a repeat region (for example after a search performed on your site).

Read More
General

Where to put your help files?

There seems to be some confusion, and lack of documentation from Macromedia as to where to place extension help files. Hopefully this will help! Read More
Error Handling

Retrieve form fields for debugging

Q

How can i view the contents of a submitted form?

A

Create an ASP page with the following code, and set your form's ACTION
attribute to point to this page.


<% Option Explicit %>
<html>
<!-- head tag -->
<body>

<%
dim fld

response.write "Result from: " & request.serverVariables("HTTP_REFERER")
response.write "<table>"
response.write "<tr><td>Field</td><td>Value</td></tr>"
for each fld in request.form
response.write "<tr><td>" & fld & "</td><td>" & request.form(fld) & "</td></tr>"
next 'fld
response.write "</table>"

%>

</body>
</html>

 

source: ASPToday

Read More
Dreamweaver

Auto Window Print

Q

How can i initialize the print function in JavaScript for a printable page, so that the user doesn't need to click a print-button ?

A

Just put this little script in your page and it will initialize the print pop-up automatically.

<script>
if (window.self) window.print();
</script>

Read More
ASP

Formating Date/Time values for different National Preferences

Q

Where can i find a Reference for Formatting Date/Time values for different National Preferences ?

A

http://www.tdsf.co.uk/tdsfdemo/LocaleIDs.asp

Read More
SQL Server

OLE and OLEDB Provider Error Codes (0x800xxxxx)

Question:

Where can i get a complete list of OLE / OLEDB Error codes and descriptions ?

Answer:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q168354&GSSNB=1

Read More
Internet Explorer

Launch a program or open a file from the browser.

I recently had a requirement where I needed to launch a program from a browser window. LaunchinIE allows you to start an appllication Word, Excel or any *.exe file from a Link on a web page.

You can download the LaunchinIE.dll and find full installation and set up instructions at the developers site: http://www.whirlywiryweb.com/q/%2Flaunchinie.asp

NOTE this will only launch a program on the local hard drive, so it's only really of use for Intranet type scenarios.

Read More
ASP

Write the EURO character

Q:

How can i write the EURO character to the browser ?

A:

Use the code below:

<%
Response.Write "&#8364;"
%>

 

source: ASPToday

Read More
Databases

Connecting OSX Classic to OSX with MySQL and PHAkT

This FAQ will attempt to explain how to make a connection from Ultradev running on a Mac's Classic environment back to a MySQL database hosted locally from Mac OSX. Read More
ASP

Number Count Beside Each Record

This FAQ will demonstrate how to display the number count beside each record when listing your records while using the Repeat Region behavior. Read More
PHP

Session under Win32

Question :

How can I get rid of the errors generated by PHP when creating a session :

Warning: open(/tmp\sess_1243d01f1b06d133deb6b9894ed040ed, O_RDWR) failed: m (2) in C:\apache\htdocs\path\to_document\login.php on line 12

 

Read More
Browser Issues

Hand Cursor with JavaScript

Question

How can i make the user aware of a button (OnClick Event) when there is now link (HREF) attached ?

Answer

Use a CSS style with a OnMouseOver event.

Create the following style in your document or CSS:

<style type="text/css">
<!--
.cursor {  cursor: hand}
-->
</style>

Attach it to the OnClick Event:

OnMouseOver="this.className='cursor';"

Read More
General

Tips for Macromedia Approved Extensions writing

Here are some tips about building extensions compilant to Macromedia Approved standards.

Read More
Error Handling

IE ASP Error Handling

I am getting those nasty error500 pages when my ASP code isn't correct and can't see any information on the error that it produces ?

Read More
Databases

Retrieve Form Values from UD4 Insert Record behavior

If you are using the ASP server model and asked yourself once, how do I retrieve the form values from the form that is associated with the UD4 Insert Record Behavior? Read this FAQ. Read More
Newer articles Older articles