INSERT Article(Category, Title) VALUES('components', 'When does ASP release COM objects?') INSERT Article(Category, Title) VALUES('components', 'How do I store objects or components in session/application variables?') INSERT Article(Category, Title) VALUES('components', 'DLL: How do I avoid ''Permission Denied'' when re-compiling?') INSERT Article(Category, Title) VALUES('components', 'Why do I get ''Server.CreateObject Access Error''?') INSERT Article(Category, Title) VALUES('components', 'Why do I get 8007000E errors?') INSERT Article(Category, Title) VALUES('components', 'Why do I get 800401F3 / 800A01AD errors?') INSERT Article(Category, Title) VALUES('components', 'How do I determine if a COM object is installed?') INSERT Article(Category, Title) VALUES('components', 'How do I detect browsers without components?') INSERT Article(Category, Title) VALUES('components', 'Why does Browscap give me ''unknown'' or tell me IE is Netscape?') INSERT Article(Category, Title) VALUES('components', 'Where can I get an updated Browscap.ini?') INSERT Article(Category, Title) VALUES('components', 'How do I pass server-side values to a client-side ActiveX control?') INSERT Article(Category, Title) VALUES('components', 'How do I generate PDF files from ASP?') INSERT Article(Category, Title) VALUES('components', 'Can I code ISAPI filters / extensions with Visual Basic?') INSERT Article(Category, Title) VALUES('components', 'Where can I get a shopping cart for my web site?') INSERT Article(Category, Title) VALUES('components', 'Why do I get 8000401A errors?') INSERT Article(Category, Title) VALUES('components', 'Should I instantiate my COM object with CreateObject or Server.CreateObject?') INSERT Article(Category, Title) VALUES('components', 'Why do I get 80040460 errors?') INSERT Article(Category, Title) VALUES('components', 'Why do I get 800A0030 errors?') INSERT Article(Category, Title) VALUES('components', 'Why do I get 8007007E errors?') INSERT Article(Category, Title) VALUES('components', 'Why do I get 800A005B errors?') INSERT Article(Category, Title) VALUES('components', 'Why do I get 80040112 / 8007045A errors?') INSERT Article(Category, Title) VALUES('components', 'Why do I get 80072EE5 errors?') INSERT Article(Category, Title) VALUES('components', 'Why do I get 80040111 errors?') INSERT Article(Category, Title) VALUES('components', 'How do I generate RTF documents from ASP?') INSERT Article(Category, Title) VALUES('components', 'How do I determine if an object exists?') INSERT Article(Category, Title) VALUES('components', 'How do I handle MD5 from ASP?') INSERT Article(Category, Title) VALUES('components', 'Why do I get 80072EE2 errors?') INSERT Article(Category, Title) VALUES('components', 'Why do I get 800C0007 errors?') INSERT Article(Category, Title) VALUES('components', 'Why do I get 80040514 errors?') INSERT Article(Category, Title) VALUES('components', 'Should I close my objects and/or set them to nothing?') INSERT Article(Category, Title) VALUES('database', 'Why do I get database-related 80004005 errors?') INSERT Article(Category, Title) VALUES('database', 'How do I hide system tables in SQL Server''s Enterprise Manager?') INSERT Article(Category, Title) VALUES('database', 'How do I determine if a number is odd or even?') INSERT Article(Category, Title) VALUES('database', 'How do I temporarily disable a trigger?') INSERT Article(Category, Title) VALUES('database', 'How do I create a database from ASP?') INSERT Article(Category, Title) VALUES('database', 'How do I deal with an apostrophe ('') in a SQL statement?') INSERT Article(Category, Title) VALUES('database', 'How do I find a stored procedure containing <text>?') INSERT Article(Category, Title) VALUES('database', 'Which is better, rs(0) or rs("fieldname")?') INSERT Article(Category, Title) VALUES('database', 'Why do I get the error ''Command text was not set for the command object''?') INSERT Article(Category, Title) VALUES('database', 'How can I tell which version of MDAC I''m running?') INSERT Article(Category, Title) VALUES('database', 'Why do I get ''Argument data type text is invalid for argument [...]''?') INSERT Article(Category, Title) VALUES('database', 'How do I solve ''Operation must use an updateable query'' errors?') INSERT Article(Category, Title) VALUES('database', 'Why should I avoid NULLs in my database?') INSERT Article(Category, Title) VALUES('database', 'What are reserved Access, ODBC and T-SQL keywords?') INSERT Article(Category, Title) VALUES('database', 'How do I get rid of Named Pipes / DBNMPNTW errors?') INSERT Article(Category, Title) VALUES('database', 'How do I solve ''ADO Could Not Find The Specified Provider''?') INSERT Article(Category, Title) VALUES('database', 'Why do I get ''Syntax Error in INSERT INTO Statement'' with Access?') INSERT Article(Category, Title) VALUES('database', 'What is wrong with ''SELECT *''?') INSERT Article(Category, Title) VALUES('database', 'What is wrong with ''LIKE *''?') INSERT Article(Category, Title) VALUES('database', 'Why do I get 800A0BB9 / 800A1391 errors?') INSERT Article(Category, Title) VALUES('database', 'Schema: How do I show all the primary keys?') INSERT Article(Category, Title) VALUES('database', 'Schema: How do I show all the triggers in a database?') INSERT Article(Category, Title) VALUES('database', 'Should I use ADOVBS.inc for declaring constants?') INSERT Article(Category, Title) VALUES('database', 'How do I sort out an AND/OR query with an unknown number of parameters?') INSERT Article(Category, Title) VALUES('database', 'How do I page through a recordset?') INSERT Article(Category, Title) VALUES('database', 'Why does ASP give me ActiveX errors when connecting to a database?') INSERT Article(Category, Title) VALUES('database', 'Schema: How do I get the stored procedures out of a database?') INSERT Article(Category, Title) VALUES('database', 'How do I make DSNs without calling my ISP?') INSERT Article(Category, Title) VALUES('database', 'Why do I get 80040E10 errors?') INSERT Article(Category, Title) VALUES('database', 'How do I handle BIT / BOOLEAN fields in a query?') INSERT Article(Category, Title) VALUES('database', 'How do I retrieve a random record?') INSERT Article(Category, Title) VALUES('database', 'I get "Login failed for user ''\''." in SQL Server, why?') INSERT Article(Category, Title) VALUES('database', 'Why does Access give me ''unspecified error'' messages?') INSERT Article(Category, Title) VALUES('database', 'How do I debug my SQL statements?') INSERT Article(Category, Title) VALUES('database', 'How do I connect to a non-default instance of SQL Server?') INSERT Article(Category, Title) VALUES('database', 'Why do I get weird results when using both AND and OR in a query?') INSERT Article(Category, Title) VALUES('database', 'How do I upload images to a database?') INSERT Article(Category, Title) VALUES('database', 'How do I prevent NULLs in my database from mucking up my HTML?') INSERT Article(Category, Title) VALUES('database', 'How can I make my SQL queries case sensitive?') INSERT Article(Category, Title) VALUES('database', 'Why do I get General error Unable to open registry key ''DriverId''?') INSERT Article(Category, Title) VALUES('database', 'How do I enable connection pooling?') INSERT Article(Category, Title) VALUES('database', 'How do I access MIN, MAX, SUM, COUNT values from SQL statements?') INSERT Article(Category, Title) VALUES('database', 'How do I know which version of SQL Server I''m running?') INSERT Article(Category, Title) VALUES('database', 'Why do I get 80040E37 errors?') INSERT Article(Category, Title) VALUES('database', 'Why does my DELETE query not work?') INSERT Article(Category, Title) VALUES('database', 'How do I connect to an Access database / text file on another web server?') INSERT Article(Category, Title) VALUES('database', 'How do I get the ID number of a just-inserted record?') INSERT Article(Category, Title) VALUES('database', 'How do I get column names and datatypes for a table?') INSERT Article(Category, Title) VALUES('database', 'Schema: How do I get the tables out of a database?') INSERT Article(Category, Title) VALUES('database', 'How do I upsize from Access to SQL Server?') INSERT Article(Category, Title) VALUES('database', 'How do I connect to SQL Server on a port other than 1433?') INSERT Article(Category, Title) VALUES('database', 'How do I deal with MEMO, TEXT, HYPERLINK, and CURRENCY columns?') INSERT Article(Category, Title) VALUES('database', 'Can I compact / repair / synchronize an Access database from ASP code?') INSERT Article(Category, Title) VALUES('database', 'When should I use a recordset object (ADODB.Recordset)?') INSERT Article(Category, Title) VALUES('database', 'Why does RecordCount return as -1?') INSERT Article(Category, Title) VALUES('database', 'How do I prevent my ASP pages from waiting for backend activity?') INSERT Article(Category, Title) VALUES('database', 'What are the limitations of Access?') INSERT Article(Category, Title) VALUES('database', 'How do I enumerate through the DSNs on a machine?') INSERT Article(Category, Title) VALUES('database', 'Where can I get basic info about using stored procedures?') INSERT Article(Category, Title) VALUES('database', 'Why doesn''t SQL Server allow me to separate DATE and TIME?') INSERT Article(Category, Title) VALUES('database', 'How do I document / compare my SQL Server database(s)?') INSERT Article(Category, Title) VALUES('database', 'What do I need to know about the differences between Access and SQL Server?') INSERT Article(Category, Title) VALUES('database', 'Why do I get SQLSetConnectAttr Failed errors?') INSERT Article(Category, Title) VALUES('database', 'Where can I get this ''Books Online'' that people keep telling me about?') INSERT Article(Category, Title) VALUES('database', 'Should I index my database table(s), and if so, how?') INSERT Article(Category, Title) VALUES('database', 'Can I start IDENTITY values at a new seed?') INSERT Article(Category, Title) VALUES('database', 'Why does Enterprise Manager crash when I get an error in a stored procedure?') INSERT Article(Category, Title) VALUES('database', 'How do I present one-to-many relationships in my ASP page?') INSERT Article(Category, Title) VALUES('database', 'Why does AbsolutePosition return as -1?') INSERT Article(Category, Title) VALUES('database', 'Schema: how do I retrieve the description property of a column?') INSERT Article(Category, Title) VALUES('database', 'How do I time my T-SQL code?') INSERT Article(Category, Title) VALUES('database', 'Why do I get ''BOF or EOF'' errors?') INSERT Article(Category, Title) VALUES('database', 'How do I simulate an array inside a stored procedure?') INSERT Article(Category, Title) VALUES('database', 'What does "ambiguous column name" mean?') INSERT Article(Category, Title) VALUES('database', 'How do I solve ''Could not find installable ISAM'' errors?') INSERT Article(Category, Title) VALUES('database', 'Can I fix this mm/dd/yyyy <-> dd/mm/yyyy confusion once and for all?') INSERT Article(Category, Title) VALUES('database', 'Why is Query Analyzer only returning 255 characters of my VARCHAR / TEXT column?') INSERT Article(Category, Title) VALUES('database', 'How do I get the number of rows in a table, or all tables?') INSERT Article(Category, Title) VALUES('database', 'Why do I get 800A0CC1 errors?') INSERT Article(Category, Title) VALUES('database', 'How do I convert columns of values into a single list?') INSERT Article(Category, Title) VALUES('database', 'How do I search for special characters (e.g. %) in SQL Server?') INSERT Article(Category, Title) VALUES('database', 'Why do I get ''object could not be found'' or ''invalid object name''?') INSERT Article(Category, Title) VALUES('database', 'Why do I get 800A0E7D errors?') INSERT Article(Category, Title) VALUES('database', 'Why do I get 80040e31 / ''Timeout Expired'' errors?') INSERT Article(Category, Title) VALUES('database', 'What is this ''Multiple-step OLE DB operation generated errors'' message?') INSERT Article(Category, Title) VALUES('database', 'Why do I get 80040E57 / 80040E07 errors?') INSERT Article(Category, Title) VALUES('database', 'Why can I not ''open a database created with a previous version...''?') INSERT Article(Category, Title) VALUES('database', 'Why do I get script errors in Enterprise Manager''s ''taskpad'' view?') INSERT Article(Category, Title) VALUES('database', 'Why do I get ''Not enough space on temporary disk'' errors?') INSERT Article(Category, Title) VALUES('database', 'How do I limit the number of records returned in my resultset?') INSERT Article(Category, Title) VALUES('database', 'Why do I get ''Operation is not allowed when the object is closed'' errors?') INSERT Article(Category, Title) VALUES('database', 'Why can''t I use LIKE ''%datepart%'' queries for dates against SQL Server?') INSERT Article(Category, Title) VALUES('database', 'How do I determine if a column exists in a given table?') INSERT Article(Category, Title) VALUES('database', 'How do I deal with multiple resultsets from a stored procedure?') INSERT Article(Category, Title) VALUES('database', 'Why do I get 800a0cb3 errors?') INSERT Article(Category, Title) VALUES('database', 'Why do I get 80040e09 errors?') INSERT Article(Category, Title) VALUES('database', 'Why do I get 800a01fb errors?') INSERT Article(Category, Title) VALUES('database', 'Why do I get 80040e30 errors?') INSERT Article(Category, Title) VALUES('database', 'Why do I get 80040e4e errors?') INSERT Article(Category, Title) VALUES('database', 'How do I protect my stored procedure code?') INSERT Article(Category, Title) VALUES('database', 'Why do I get 80040200 / 80040514 / 800A0E7A errors?') INSERT Article(Category, Title) VALUES('database', 'How do I get the latest version of the JET OLEDB drivers?') INSERT Article(Category, Title) VALUES('database', 'What are the limitations of MSDE?') INSERT Article(Category, Title) VALUES('database', 'What are the capacity specifications for Access, SQL Server, and MSDE?') INSERT Article(Category, Title) VALUES('database', 'Can I have optional parameters to my stored procedures?') INSERT Article(Category, Title) VALUES('database', 'How do I determine if a table exists in the database?') INSERT Article(Category, Title) VALUES('database', 'How do I determine if a database exists?') INSERT Article(Category, Title) VALUES('database', 'How do I handle alphabetic pagination?') INSERT Article(Category, Title) VALUES('database', 'What datatype should I use for my character-based database columns?') INSERT Article(Category, Title) VALUES('database', 'How do I start SQL Server Agent from ASP?') INSERT Article(Category, Title) VALUES('database', 'Why do I get 80040E21 errors?') INSERT Article(Category, Title) VALUES('database', 'Why do I get 800A0C93 errors?') INSERT Article(Category, Title) VALUES('database', 'Why do I get 80040E2F errors?') INSERT Article(Category, Title) VALUES('database', 'Why do I get 80040E24 errors?') INSERT Article(Category, Title) VALUES('database', 'Can I use the NZ() function without getting 80040E14 errors?') INSERT Article(Category, Title) VALUES('database', 'Why do I get 80040E14 errors?') INSERT Article(Category, Title) VALUES('database', 'Why do I get 8002000A errors?') INSERT Article(Category, Title) VALUES('database', 'Why do I get 80070070 errors?') INSERT Article(Category, Title) VALUES('database', 'Why do I get 80040E54 errors?') INSERT Article(Category, Title) VALUES('database', 'Where else can I learn about SQL Server?') INSERT Article(Category, Title) VALUES('database', 'Which database should I use for my ASP application?') INSERT Article(Category, Title) VALUES('database', 'How do I return row numbers with my query?') INSERT Article(Category, Title) VALUES('database', 'How do I get a list of tables and their record counts?') INSERT Article(Category, Title) VALUES('database', 'How do I remove duplicate rows from a database table?') INSERT Article(Category, Title) VALUES('database', 'How do I get the correct date/time from the msdb.sysjob* tables?') INSERT Article(Category, Title) VALUES('database', 'Why is my app slow after upgrading from SQL Server 7 to 2000?') INSERT Article(Category, Title) VALUES('database', 'Why can''t I use the TOP keyword?') INSERT Article(Category, Title) VALUES('database', 'Why do I get errors about master..spt_values?') INSERT Article(Category, Title) VALUES('database', 'How do I find all the available SQL Servers on my network?') INSERT Article(Category, Title) VALUES('database', 'How do I output a SQL Server query to a text file?') INSERT Article(Category, Title) VALUES('database', 'How do I use GETDATE() within a User-Defined Function (UDF)?') INSERT Article(Category, Title) VALUES('database', 'Why am I having problems with SQL Server 2000 SP3?') INSERT Article(Category, Title) VALUES('database', 'How do I protect myself against the W32.Slammer worm?') INSERT Article(Category, Title) VALUES('database', 'How do I manage SQL Server / MSDE?') INSERT Article(Category, Title) VALUES('database', 'How do I handle REPLACE() within a TEXT column in SQL Server?') INSERT Article(Category, Title) VALUES('database', 'Why is tempdb full, and how can I prevent this from happening?') INSERT Article(Category, Title) VALUES('database', 'How do I get the nth row in a table?') INSERT Article(Category, Title) VALUES('database', 'How do I monitor when data changes in a SQL Server table?') INSERT Article(Category, Title) VALUES('database', 'How do I recover data from SQL Server''s log files?') INSERT Article(Category, Title) VALUES('database', 'How should I store an IP address in SQL Server?') INSERT Article(Category, Title) VALUES('database', 'How do I convert a SQL Server DATETIME value to a Unix timestamp?') INSERT Article(Category, Title) VALUES('database', 'How do I protect my Access database (MDB file)?') INSERT Article(Category, Title) VALUES('database', 'Which tool should I use: Enterprise Manager or Query Analyzer?') INSERT Article(Category, Title) VALUES('database', 'Schema: How do I get a list of databases in my server?') INSERT Article(Category, Title) VALUES('database', 'How do I determine if a specific SQL Server table exists?') INSERT Article(Category, Title) VALUES('database', 'How do I upsize my MSDE database to full-blown SQL Server 2000?') INSERT Article(Category, Title) VALUES('database', 'Can I make SQL Server format dates and times for me?') INSERT Article(Category, Title) VALUES('database', 'Why can''t I install SQL Server on Windows Server 2003?') INSERT Article(Category, Title) VALUES('database', 'How do I write a SQL query that turns rows into columns, or vice-versa?') INSERT Article(Category, Title) VALUES('database', 'How do I list the parameters (and datatypes) for a stored procedure?') INSERT Article(Category, Title) VALUES('database', 'What are all the valid style parameters for converting datetime values to strings?') INSERT Article(Category, Title) VALUES('database', 'Where can I learn about "Yukon" - the next version of SQL Server?') INSERT Article(Category, Title) VALUES('database', 'How can I learn more about undocumented SQL Server stored procedures?') INSERT Article(Category, Title) VALUES('dates', 'How do I delimit dates for inserting/updating a database?') INSERT Article(Category, Title) VALUES('dates', 'Why does JavaScript''s document.lastModified() not work in ASP files?') INSERT Article(Category, Title) VALUES('dates', 'Could I get a little help with dates?') INSERT Article(Category, Title) VALUES('dates', 'How do I select time only from a DATETIME column?') INSERT Article(Category, Title) VALUES('dates', 'Can I get millisecond accuracy in ASP?') INSERT Article(Category, Title) VALUES('dates', 'How do I display time in military format?') INSERT Article(Category, Title) VALUES('dates', 'How do I convert local time to UTC (GMT) time?') INSERT Article(Category, Title) VALUES('dates', 'How do I determine the number of seconds since 1/1/1970?') INSERT Article(Category, Title) VALUES('dates', 'Given two dates, how do I determine an age?') INSERT Article(Category, Title) VALUES('dates', 'How do I convert a timespan, in seconds, to HH:MM:SS?') INSERT Article(Category, Title) VALUES('dates', 'Should I use ''BETWEEN'' for date queries?') INSERT Article(Category, Title) VALUES('dates', 'How do I implement a calendar / datepicker in ASP?') INSERT Article(Category, Title) VALUES('dates', 'How do I format a date in ways not offered by FormatDateTime?') INSERT Article(Category, Title) VALUES('dates', 'Why do I have problems inserting NOW() into a database?') INSERT Article(Category, Title) VALUES('dates', 'Are there any shortcuts to calculating dates, such as first day of the month?') INSERT Article(Category, Title) VALUES('dates', 'How do I count the number of business days between two dates?') INSERT Article(Category, Title) VALUES('email', 'How do I send e-mail with CDONTS?') INSERT Article(Category, Title) VALUES('email', 'How do I put carriage returns into an e-mail?') INSERT Article(Category, Title) VALUES('email', 'How do I send e-mail from ASP?') INSERT Article(Category, Title) VALUES('email', 'How do I validate an e-mail address?') INSERT Article(Category, Title) VALUES('email', 'Can I get CDO messages to return a read receipt?') INSERT Article(Category, Title) VALUES('email', 'Why do CDONTS messages end up in the badmail folder?') INSERT Article(Category, Title) VALUES('email', 'Why does my CDONTS mail hang out in the queue or pickup folders?') INSERT Article(Category, Title) VALUES('email', 'Why can''t ASP handle 80,000 e-mails?') INSERT Article(Category, Title) VALUES('email', 'How do I prevent my links from wrapping in an e-mail?') INSERT Article(Category, Title) VALUES('email', 'Why does CDO.Message give me an 8004020f error?') INSERT Article(Category, Title) VALUES('email', 'Where can I get more information about configuring and using CDO / CDONTS?') INSERT Article(Category, Title) VALUES('email', 'How do I alter the priority of a CDO message?') INSERT Article(Category, Title) VALUES('email', 'Can I use a remote SMTP server with CDONTS.NewMail?') INSERT Article(Category, Title) VALUES('email', 'Why do I get 8000900F errors?') INSERT Article(Category, Title) VALUES('email', 'Why do I get C00402CE / C00402C7 errors?') INSERT Article(Category, Title) VALUES('email', 'Why do I get 80090020 errors?') INSERT Article(Category, Title) VALUES('email', 'Why do I get 8004020A errors?') INSERT Article(Category, Title) VALUES('email', 'Why do I get 80040108 errors?') INSERT Article(Category, Title) VALUES('email', 'How do I send e-mail from SQL Server?') INSERT Article(Category, Title) VALUES('email', 'Why does CDO.Message give me 80040213 errors?') INSERT Article(Category, Title) VALUES('email', 'Why does CDO.Message give me 80040222 errors?') INSERT Article(Category, Title) VALUES('filesystem', 'How do I sort a list of files?') INSERT Article(Category, Title) VALUES('filesystem', 'Where can I find info on working with files and FileSystemObject?') INSERT Article(Category, Title) VALUES('filesystem', 'How do I dynamically include files?') INSERT Article(Category, Title) VALUES('filesystem', 'How do I get the name of the current URL / page?') INSERT Article(Category, Title) VALUES('filesystem', 'Can I rename a file using FileSystemObject?') INSERT Article(Category, Title) VALUES('filesystem', 'Why do I get ''Disk not ready'' errors with FileSystemObject?') INSERT Article(Category, Title) VALUES('filesystem', 'Why do I get ''Path not found'' errors with FileSystemObject?') INSERT Article(Category, Title) VALUES('filesystem', 'Why do I get ''Permission Denied'' errors with FileSystemObject?') INSERT Article(Category, Title) VALUES('filesystem', 'Why do I get ''Invalid procedure call or argument''?') INSERT Article(Category, Title) VALUES('filesystem', 'How do I make the filename correct for the client, when using binaryWrite?') INSERT Article(Category, Title) VALUES('filesystem', 'How do I create / manipulate images from ASP?') INSERT Article(Category, Title) VALUES('filesystem', 'Why does FileSystemObject hang all of a sudden?') INSERT Article(Category, Title) VALUES('filesystem', 'Why do I get permissions errors after upgrading to Windows XP?') INSERT Article(Category, Title) VALUES('filesystem', 'Can I include a file in both server-side script and client-side script?') INSERT Article(Category, Title) VALUES('filesystem', 'How do I get a list of a folder''s subfolders?') INSERT Article(Category, Title) VALUES('filesystem', 'Can I place a file on a user''s hard drive without bothering them with a prompt?') INSERT Article(Category, Title) VALUES('filesystem', 'How do I prevent people from ''leeching'' my images?') INSERT Article(Category, Title) VALUES('filesystem', 'How do I prevent people from ''leeching'' my CSS or JS files?') INSERT Article(Category, Title) VALUES('filesystem', 'How do I prevent that ugly red x when an image is missing from my server?') INSERT Article(Category, Title) VALUES('filesystem', 'How do I determine the owner of a file?') INSERT Article(Category, Title) VALUES('filesystem', 'Why do I get an ''Invalid Path Character'' error?') INSERT Article(Category, Title) VALUES('filesystem', 'How do I change the modified time of a file?') INSERT Article(Category, Title) VALUES('filesystem', 'Why is ''the operation completed successfully'' an error message?') INSERT Article(Category, Title) VALUES('filesystem', 'Why do I get 800A0034 errors?') INSERT Article(Category, Title) VALUES('filesystem', 'Why do I get 800A0BBA errors?') INSERT Article(Category, Title) VALUES('filesystem', 'How do I use FileSystemObject to create a file on the client?') INSERT Article(Category, Title) VALUES('filesystem', 'How do I retrieve a random file?') INSERT Article(Category, Title) VALUES('forms', 'How do I retrieve the name of the form that was submitted?') INSERT Article(Category, Title) VALUES('forms', 'Why does my input type=text value get truncated?') INSERT Article(Category, Title) VALUES('forms', 'Why does my form variable become ''value, value'' instead of ''value''?') INSERT Article(Category, Title) VALUES('forms', 'How do I validate a credit card number in ASP?') INSERT Article(Category, Title) VALUES('forms', 'How do I iterate through a form collection?') INSERT Article(Category, Title) VALUES('forms', 'How do I change the target frame or window of a response.redirect?') INSERT Article(Category, Title) VALUES('forms', 'What is the size limit of a posted FORM field?') INSERT Article(Category, Title) VALUES('forms', 'How do I validate forms using server side script?') INSERT Article(Category, Title) VALUES('forms', 'Which is faster: Request("item") or Request.Form("item")?') INSERT Article(Category, Title) VALUES('forms', 'How do I cause/prevent ENTER being used to submit a form?') INSERT Article(Category, Title) VALUES('forms', 'How can I mimic a client-side POST from ASP?') INSERT Article(Category, Title) VALUES('forms', 'When I''m uploading files, why can''t I access the request.form collection?') INSERT Article(Category, Title) VALUES('forms', 'How do I upload files from the client to the server?') INSERT Article(Category, Title) VALUES('forms', 'How do I pass x-y coordinates to ASP, after the user clicks an image?') INSERT Article(Category, Title) VALUES('forms', 'How do I disable certain FORM elements?') INSERT Article(Category, Title) VALUES('forms', 'How do I perform spell checking from a web page?') INSERT Article(Category, Title) VALUES('forms', 'What is the limit on QueryString / GET / URL parameters?') INSERT Article(Category, Title) VALUES('forms', 'What is the limit on Form / POST parameters?') INSERT Article(Category, Title) VALUES('forms', 'How do I disable IE''s Autocomplete feature?') INSERT Article(Category, Title) VALUES('forms', 'How do I make form fields read-only?') INSERT Article(Category, Title) VALUES('forms', 'How can I programmatically interfere with the INPUT TYPE=FILE element?') INSERT Article(Category, Title) VALUES('forms', 'When I have multiple submit buttons, how do I tell which was clicked?') INSERT Article(Category, Title) VALUES('forms', 'Why do I get ''HTTP 405 - Resource Not Allowed'' errors?') INSERT Article(Category, Title) VALUES('forms', 'Why won''t my <TEXTAREA> display the data I passed to it from ASP?') INSERT Article(Category, Title) VALUES('forms', 'How do I retrieve the text and the value from a <SELECT> element?') INSERT Article(Category, Title) VALUES('forms', 'How do I make one dropdown depend on another?') INSERT Article(Category, Title) VALUES('forms', 'How do I submit a form to a new window, with the control of window.open()?') INSERT Article(Category, Title) VALUES('general', 'How do I make JavaScript send values to ASP?') INSERT Article(Category, Title) VALUES('general', 'How do I make sure people go to page x before page y?') INSERT Article(Category, Title) VALUES('general', 'How can I stop Photoshop from opening ASP files?') INSERT Article(Category, Title) VALUES('general', 'Why does my page render (properly) in IE and not in Netscape?') INSERT Article(Category, Title) VALUES('general', 'Why can''t I browse localhost without a connection?') INSERT Article(Category, Title) VALUES('general', 'Why am I having problems with Server.Execute and/or Server.Transfer?') INSERT Article(Category, Title) VALUES('general', 'Why do I get an ''overflow'' error using CInt?') INSERT Article(Category, Title) VALUES('general', 'Why do I get an HTTP Header or Object Moved error when trying to redirect?') INSERT Article(Category, Title) VALUES('general', 'How do I get the user''s IP address or browser information?') INSERT Article(Category, Title) VALUES('general', 'Can I detect plug-ins/ActiveX controls from ASP?') INSERT Article(Category, Title) VALUES('general', 'How do I control printing from ASP?') INSERT Article(Category, Title) VALUES('general', 'How do I disable the back/forward buttons?') INSERT Article(Category, Title) VALUES('general', 'Where can I find out about running Perl in IIS?') INSERT Article(Category, Title) VALUES('general', 'How do I access my server''s registry from an ASP page?') INSERT Article(Category, Title) VALUES('general', 'How do I prevent my ASP pages from caching?') INSERT Article(Category, Title) VALUES('general', 'How do I make Visual InterDev''s debugging features work?') INSERT Article(Category, Title) VALUES('general', 'Why won''t QueryString values work with Server.Execute?') INSERT Article(Category, Title) VALUES('general', 'How do I execute a ping command from ASP, and retrieve the results?') INSERT Article(Category, Title) VALUES('general', 'Can I run IIS 5.0 / ASP 3.0 on Windows NT 4.0 or Windows 9x?') INSERT Article(Category, Title) VALUES('general', 'How do I get screen resolution from ASP?') INSERT Article(Category, Title) VALUES('general', 'Why does REMOTE_HOST return an IP address instead of a name address?') INSERT Article(Category, Title) VALUES('general', 'Does order matter when using different languages in ASP?') INSERT Article(Category, Title) VALUES('general', 'How do I get the login name / username from the person visiting my page?') INSERT Article(Category, Title) VALUES('general', 'Why can''t I use #EXEC in an ASP page?') INSERT Article(Category, Title) VALUES('general', 'Why do I get ''HTTP/1.0 Invalid Application Name'' errors?') INSERT Article(Category, Title) VALUES('general', 'How do I fix the ::$DATA bug?') INSERT Article(Category, Title) VALUES('general', 'What is this ''Cannot detect OS type'' error with NT 4.0 Option Pack?') INSERT Article(Category, Title) VALUES('general', 'How do I persist a shopping cart without session variables?') INSERT Article(Category, Title) VALUES('general', 'How do I use ASP to [...]') INSERT Article(Category, Title) VALUES('general', 'Can I host multiple sites in Workstation or Professional?') INSERT Article(Category, Title) VALUES('general', 'How do I detect ENABLED cookies / javascript?') INSERT Article(Category, Title) VALUES('general', 'How do I execute a DOS command / batch file / exe from ASP?') INSERT Article(Category, Title) VALUES('general', 'How do I use extensions other than .ASP for ASP files?') INSERT Article(Category, Title) VALUES('general', 'How do I embed a TAB character into source code?') INSERT Article(Category, Title) VALUES('general', 'Where can I host ASP pages for free (or at least cheap)?') INSERT Article(Category, Title) VALUES('general', 'How do I embed apostrophes ('') and quotes (") in a string?') INSERT Article(Category, Title) VALUES('general', 'How do I increase timeout values?') INSERT Article(Category, Title) VALUES('general', 'Can I create an array''s size dynamically?') INSERT Article(Category, Title) VALUES('general', 'How do I get the lbound/ubound of the nth element in a multi-dimensional array?') INSERT Article(Category, Title) VALUES('general', 'Can I use IP address to uniquely identify visitors?') INSERT Article(Category, Title) VALUES('general', 'Why can''t I pass querystring information AND links to #bookmarks?') INSERT Article(Category, Title) VALUES('general', 'What''s the deal with IIS 5.0 and ASP 3.0?') INSERT Article(Category, Title) VALUES('general', 'Where do I get ASP?') INSERT Article(Category, Title) VALUES('general', 'Why does global.asa not fire?') INSERT Article(Category, Title) VALUES('general', 'What is wrong with Session_OnEnd()?') INSERT Article(Category, Title) VALUES('general', 'Can I run IIS on Windows Millennium or Windows XP Home?') INSERT Article(Category, Title) VALUES('general', 'How do I make sure my ASP question gets answered?') INSERT Article(Category, Title) VALUES('general', 'When I run a page in my browser, why does the ASP code not execute?') INSERT Article(Category, Title) VALUES('general', 'Should I use sessionID to uniquely identify users (e.g. primary key)?') INSERT Article(Category, Title) VALUES('general', 'How do I time my ASP code?') INSERT Article(Category, Title) VALUES('general', 'Can I dictate the load order of files on the client from ASP?') INSERT Article(Category, Title) VALUES('general', 'How do I access all active sessions on the server?') INSERT Article(Category, Title) VALUES('general', 'Why do I get ''Name redefined'' errors?') INSERT Article(Category, Title) VALUES('general', 'What is this error ''An unhandled data type was encountered''?') INSERT Article(Category, Title) VALUES('general', 'How do I embed ASP delimiters (<% or %>) in a string?') INSERT Article(Category, Title) VALUES('general', 'Where can I find out about .NET?') INSERT Article(Category, Title) VALUES('general', 'How do I host multiple web sites on one IIS box?') INSERT Article(Category, Title) VALUES('general', 'How do I generate unique GUIDs from ASP?') INSERT Article(Category, Title) VALUES('general', 'Why do I get a 500 Internal Server error for all ASP errors?') INSERT Article(Category, Title) VALUES('general', 'How do I FTP files from ASP?') INSERT Article(Category, Title) VALUES('general', 'Why is Netscape slow in IIS 5.0?') INSERT Article(Category, Title) VALUES('general', 'How do I control access to an area?') INSERT Article(Category, Title) VALUES('general', 'Why do I get 800A0414 errors?') INSERT Article(Category, Title) VALUES('general', 'How do I round a number *properly* with VBScript?') INSERT Article(Category, Title) VALUES('general', 'Why do I get an error about a ''Smart HTML interpreter''?') INSERT Article(Category, Title) VALUES('general', 'How do I change document names / extensions in IIS / PWS?') INSERT Article(Category, Title) VALUES('general', 'How do I solve ''The server failed to load the application'' errors?') INSERT Article(Category, Title) VALUES('general', 'What do I do when IIS 5.0 will not start?') INSERT Article(Category, Title) VALUES('general', 'How do I know which version of VBScript my server is running?') INSERT Article(Category, Title) VALUES('general', 'Why do I get script errors on one machine but not another?') INSERT Article(Category, Title) VALUES('general', 'How do I solve ''The specified procedure could not be found'' errors?') INSERT Article(Category, Title) VALUES('general', 'How do I stress test my ASP application?') INSERT Article(Category, Title) VALUES('general', 'How do I determine which version of IIS / ASP I''m running?') INSERT Article(Category, Title) VALUES('general', 'How do I make my ASP page pause or ''sleep''?') INSERT Article(Category, Title) VALUES('general', 'How do I schedule ASP files?') INSERT Article(Category, Title) VALUES('general', 'How do I refresh global.asa without restarting the application?') INSERT Article(Category, Title) VALUES('general', 'Why does IIS 5.0 stop serving ASP pages?') INSERT Article(Category, Title) VALUES('general', 'Is there an easier way to patch my server(s)?') INSERT Article(Category, Title) VALUES('general', 'How do I detect the browser''s encryption level / cipher strength?') INSERT Article(Category, Title) VALUES('general', 'Why won''t my session variables stick?') INSERT Article(Category, Title) VALUES('general', 'How do I make my ASP page refresh?') INSERT Article(Category, Title) VALUES('general', 'How do I prompt a "Save As" dialog for an accepted mime type?') INSERT Article(Category, Title) VALUES('general', 'How can I give them a better 404 message?') INSERT Article(Category, Title) VALUES('general', 'How do I protect my ASP code?') INSERT Article(Category, Title) VALUES('general', 'How do I get IntelliSense to see ASP 3.0 methods?') INSERT Article(Category, Title) VALUES('general', 'What is wrong with Request.ServerVariables("HTTP_REFERER")?') INSERT Article(Category, Title) VALUES('general', 'What is this ''ASP 0115'' error?') INSERT Article(Category, Title) VALUES('general', 'How do I manage a session across multiple windows?') INSERT Article(Category, Title) VALUES('general', 'How do I read the contents of a remote web page?') INSERT Article(Category, Title) VALUES('general', 'How do I protect my client-side JavaScript code?') INSERT Article(Category, Title) VALUES('general', 'Should I use VBScript or JScript for ASP?') INSERT Article(Category, Title) VALUES('general', 'How do I comment blocks of ASP code?') INSERT Article(Category, Title) VALUES('general', 'How do I run ASP on other web servers besides IIS?') INSERT Article(Category, Title) VALUES('general', 'Where else can I learn about ASP?') INSERT Article(Category, Title) VALUES('general', 'How do I zip / unzip files from ASP?') INSERT Article(Category, Title) VALUES('general', 'I have plenty of RAM, why do I get an ''Out of memory'' error?') INSERT Article(Category, Title) VALUES('general', 'How do I send a MsgBox or InputBox from ASP?') INSERT Article(Category, Title) VALUES('general', 'How do I turn a KB Article #, like Q191987, into a usable URL?') INSERT Article(Category, Title) VALUES('general', 'How can I increase the amount of connections in Workstation / Professional?') INSERT Article(Category, Title) VALUES('general', 'How do I change the default server scripting language in InterDev?') INSERT Article(Category, Title) VALUES('general', 'How do I convert exchange rates in ASP?') INSERT Article(Category, Title) VALUES('general', 'What do I need to know about Response.Redirect?') INSERT Article(Category, Title) VALUES('general', 'Why do I get ''Type Mismatch'' when using the Session object?') INSERT Article(Category, Title) VALUES('general', 'What kind of object is Response.Crackers?') INSERT Article(Category, Title) VALUES('general', 'What is Event ID 36, and how can I get IIS running again?') INSERT Article(Category, Title) VALUES('general', 'Why does DLLHOST.EXE take all my memory and/or CPU?') INSERT Article(Category, Title) VALUES('general', 'How do I display the Euro symbol (€) in my ASP pages?') INSERT Article(Category, Title) VALUES('general', 'How do I make the search engines index my ASP pages with QueryStrings?') INSERT Article(Category, Title) VALUES('general', 'How do I protect my images and other visual content?') INSERT Article(Category, Title) VALUES('general', 'How do I change a list into a set of table rows and columns?') INSERT Article(Category, Title) VALUES('general', 'Can I perform simple encryption / decryption in ASP?') INSERT Article(Category, Title) VALUES('general', 'How do I find out the amount of space left on my server?') INSERT Article(Category, Title) VALUES('general', 'How can I track when my site is added to a user''s favorites?') INSERT Article(Category, Title) VALUES('general', 'Why are people telling me to fix my clock / timezone?') INSERT Article(Category, Title) VALUES('general', 'Why am I having problems installing Visual Studio.NET RTM?') INSERT Article(Category, Title) VALUES('general', 'Why can''t I retrieve custom header information from Request.ServerVariables()?') INSERT Article(Category, Title) VALUES('general', 'Why can''t I turn buffering off using Response.Buffer in IIS 5.0 and up?') INSERT Article(Category, Title) VALUES('general', 'How do I get the computer name / IP address of the server?') INSERT Article(Category, Title) VALUES('general', 'How do I warn people when their session is about to expire?') INSERT Article(Category, Title) VALUES('general', 'Why do I get ''HTTP 500-12 Application Restarting'' errors?') INSERT Article(Category, Title) VALUES('general', 'Why do I get ''The RPC Server is Unavailable'' messages?') INSERT Article(Category, Title) VALUES('general', 'Should I use the .inc extension for my include files?') INSERT Article(Category, Title) VALUES('general', 'How do I convert numbers into words?') INSERT Article(Category, Title) VALUES('general', 'How do I set session variables from client-side script?') INSERT Article(Category, Title) VALUES('general', 'Why do I get the error Object Required: ''''?') INSERT Article(Category, Title) VALUES('general', 'Why does session.abandon not take effect right away?') INSERT Article(Category, Title) VALUES('general', 'How do I make sure the client is still connected before processing?') INSERT Article(Category, Title) VALUES('general', 'What is this ''A script block cannot be placed inside another script block'' error?') INSERT Article(Category, Title) VALUES('general', 'How do I deal with disappearing application variables?') INSERT Article(Category, Title) VALUES('general', 'How do I perform a Whois / DNS lookup from ASP?') INSERT Article(Category, Title) VALUES('general', 'How do I convert a name to proper case?') INSERT Article(Category, Title) VALUES('general', 'How do I pad digits with leading zeros?') INSERT Article(Category, Title) VALUES('general', 'How do I prevent ''Invalid use of Null'' errors?') INSERT Article(Category, Title) VALUES('general', 'Why do I get ''Object doesn''t support this property or method'' errors?') INSERT Article(Category, Title) VALUES('general', 'How do I generate a treeview from ASP?') INSERT Article(Category, Title) VALUES('general', 'Why am I getting ''subscript out of range'' errors?') INSERT Article(Category, Title) VALUES('general', 'Why do I get 80090016 errors?') INSERT Article(Category, Title) VALUES('general', 'How do I redirect a user to https:// if they access a page with only http://?') INSERT Article(Category, Title) VALUES('general', 'Why do I get 8000FFFF / 8002802B errors?') INSERT Article(Category, Title) VALUES('general', 'Why do I get 80020003 errors?') INSERT Article(Category, Title) VALUES('general', 'Why do I get 80010108 errors?') INSERT Article(Category, Title) VALUES('general', 'How do I convert old IDC / HTX pages to ASP?') INSERT Article(Category, Title) VALUES('general', 'Why do I get 80020005 errors?') INSERT Article(Category, Title) VALUES('general', 'Why do I get 80029c84 errors?') INSERT Article(Category, Title) VALUES('general', 'Can I mimic VBScript''s trim, ltrim, rtrim in server-side JScript / JavaScript?') INSERT Article(Category, Title) VALUES('general', 'How do I get the server''s timezone information?') INSERT Article(Category, Title) VALUES('general', 'How do I log / track ASP errors on my web site?') INSERT Article(Category, Title) VALUES('general', 'How do I convert from Hex to Decimal and back?') INSERT Article(Category, Title) VALUES('general', 'How do I highlight words in a string?') INSERT Article(Category, Title) VALUES('general', 'What could cause all of my session or application variables to disappear?') INSERT Article(Category, Title) VALUES('general', 'Can I have optional parameters to my subs / functions?') INSERT Article(Category, Title) VALUES('general', 'How do I solve ''Event ID 5'' errors?') INSERT Article(Category, Title) VALUES('general', 'How do I solve ''The Requested Resource is in Use'' errors?') INSERT Article(Category, Title) VALUES('general', 'Why does GUID not work correctly with response.write?') INSERT Article(Category, Title) VALUES('general', 'Why do I get 80070057 errors?') INSERT Article(Category, Title) VALUES('general', 'Why do I get 800A0401 errors?') INSERT Article(Category, Title) VALUES('general', 'Why do I get 800A01F4 errors?') INSERT Article(Category, Title) VALUES('general', 'Why do I get ASP 0113 / Script timed out errors?') INSERT Article(Category, Title) VALUES('general', 'Why do I get 800A03F6 errors?') INSERT Article(Category, Title) VALUES('general', 'How do I make hyperlinks out of plain text URLs and e-mail addresses?') INSERT Article(Category, Title) VALUES('general', 'Why do I get ''Invalid Default Script Language'' errors?') INSERT Article(Category, Title) VALUES('general', 'Why do I get 800A01C2 errors?') INSERT Article(Category, Title) VALUES('general', 'Why do I get 800A01CA errors?') INSERT Article(Category, Title) VALUES('general', 'Why do I get ASP 0158 errors?') INSERT Article(Category, Title) VALUES('general', 'Why do I get 800A0408 errors?') INSERT Article(Category, Title) VALUES('general', 'Why do I get 8004E00F errors?') INSERT Article(Category, Title) VALUES('general', 'Why do I get 800A138F errors?') INSERT Article(Category, Title) VALUES('general', 'Why do I get ASP 0101 errors?') INSERT Article(Category, Title) VALUES('general', 'Why do I get 8002000E errors?') INSERT Article(Category, Title) VALUES('general', 'Why do I get errors in the 800A0001 -> 800A000F range?') INSERT Article(Category, Title) VALUES('general', 'Why does IsNumeric() return true for some strings that contain characters?') INSERT Article(Category, Title) VALUES('general', 'Why do I get 80070034 / 80070035 errors?') INSERT Article(Category, Title) VALUES('general', 'How do I print the first n characters of a large block of text?') INSERT Article(Category, Title) VALUES('general', 'How do I make sure an entered string contains only valid characters?') INSERT Article(Category, Title) VALUES('general', 'How do I parse the domain name out of a URL?') INSERT Article(Category, Title) VALUES('general', 'How do I parse the file name out of a path or URL?') INSERT Article(Category, Title) VALUES('general', 'How do I decode an encoded URL?') INSERT Article(Category, Title) VALUES('general', 'Why do I get 80070056 errors?') INSERT Article(Category, Title) VALUES('general', 'Why do I get ASP 0130 / ASP 0131 errors?') INSERT Article(Category, Title) VALUES('general', 'Why do I get non-database-related 80004005 errors?') INSERT Article(Category, Title) VALUES('general', 'Why do I get errors in the 800A0400 -> 800A0415 range?') INSERT Article(Category, Title) VALUES('general', 'How do I make sure my servers have the same time?') INSERT Article(Category, Title) VALUES('general', 'Why do I get 800A03EC errors?') INSERT Article(Category, Title) VALUES('general', 'Why do I get 80010105 errors?') INSERT Article(Category, Title) VALUES('general', 'Why do I get 800A01F9 errors?') INSERT Article(Category, Title) VALUES('general', 'Why do I get 80020009 errors?') INSERT Article(Category, Title) VALUES('general', 'Why do I get errors in the 800A0030 -> 800A003A range?') INSERT Article(Category, Title) VALUES('general', 'How do I make my ASP pages more efficient?') INSERT Article(Category, Title) VALUES('general', 'How do I count the number of times x occurs in string y?') INSERT Article(Category, Title) VALUES('general', 'How do I put my ASP application onto a CD-Rom?') INSERT Article(Category, Title) VALUES('general', 'I called Session.Abandon, why are my session variables still there?') INSERT Article(Category, Title) VALUES('general', 'How do I prevent people from printing my ASP page?')