| Groups | Blog | Home |
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Firebird 1.5 Posted by - - Vivian - - - - - - at 6/14/2004 8:19:23 PM Where see examples of use ASP with Firebird ?
thanks
Vivian
...more >>
OLD ASP ... how to set a ADO param to Null Posted by Stewart Rogers at 6/14/2004 7:24:07 PM I am doing a loop in which the Date field is sometimes
null
How do I update a Stored Proc parameter to null
I am looking for something like:
Cmd.Parameter("@NewDate").value = null
Thanks in advance,
Stewart Rogers...more >>
Cloning a record ? Posted by Evertjan. at 6/14/2004 7:14:16 PM How do I clone a record, given it's ID,
to a new record copying all fields but the autoincrement ID field?
INSERT INTO myTbl (SELECT * FROM myTbl WHERE ID=17)
[This is more pseudocode than a real attempt]
I am using the Jet engine.
--
Evertjan.
The Netherlands.
(Please change the x'...more >>
Unspecified error Posted by 3legs at 6/14/2004 2:07:52 PM When openning the database, sometimes (yes, not always) it gives the error:
"Unspecified error". How could I trace what the problem was?
...more >>
Testing and Analysis Tools? Posted by Lee Mundie at 6/14/2004 1:57:42 PM Hi,
I'm nearing the end of my site development (currently ASP and Access
moving to SQL) and am looking for site testing tools...
In particular looking for load testing and concurrent connection analysis to
see where site might be heavy or pages leave connections open!
Can anyone recommend...more >>
HELP! - Need SQL code for pulling table name Posted by jeremy_zifchock NO[at]SPAM yahoo.com at 6/14/2004 5:53:57 AM I am having trouble finding the SQL to pull the table name to precede
the fld.Name since I am pulling from two different tables. Any
ideas?? Thanks in advance! Here's the code:
<%@ language = "JavaScript" %>
<head>
<script language="JavaScript">
<!--
<%
var srch="";
var sql2="";
...more >>
Error 500 on second Open to Access Database Posted by mcse4cash NO[at]SPAM hotmail.com at 6/13/2004 9:19:05 PM Using ASP under IIS (Win2k3 Server), latest patches.
I have an simple page that accesses an Access database via a system
DSN. The first Open works fine, but each subsequent time (page
reload, relogin, etc) I get either an Error 500 (HTTP error) or an ASP
"Unspecified error" message on the Ope...more >>
Zero length strings Posted by William E Hatto at 6/13/2004 6:23:02 PM Hi All,
What is the best way to handle zero length variables when inserting data
into a table. I have text field and date fields, both of which have no data
in them from time to time.
I have been using this for the text fields.
If myData="" then myData=" "
I have used the same for date...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Too Many Client tasks Posted by Brian at 6/13/2004 1:09:57 PM I have a problem with a web server that has about 125 web
sites on it. It appears that someone or several people
are not closing their connections. I keep getting the
error "too many client tasks" . I need to know if there
is any way to troubleshoot this, like see what user has
what connec...more >>
Oracle Configuration for Dreamweaver MX2004 Posted by Surya at 6/12/2004 3:44:05 PM Hi..
I'm using oracle 8i with dreaweaver to host ASP application.. is there any
easy way to connect Oracle thru DSN less connection on MM Dreamweaver as I
need to put Grid in my pages ..
Thanks in advance
Surya
...more >>
ASP Web Based nslookup Posted by TomT at 6/12/2004 11:16:57 AM Hi,
I've been searching but have not been able to find a script that will allow
nslookup's using ASP.
I'm looking to use a form, that will allow users to enter IP addresses or
domian names, then preform nslookup type of searches on the entered
information.
This is for a test server, so wou...more >>
Accessing data from an MS Access database on a remote web server Posted by Tom at 6/11/2004 10:37:01 PM Please forgive me if I have posted this to the wrong group! I have written a VB6 application that works fine. With that said, I would like to add the functionality of making the application send the Registered User ID and Serial Number to my web site and verify from an MS Access database that the ...more >>
include file Posted by +FarmerPickles at 6/11/2004 10:22:05 PM Dumb question, but how do you use an include file from another foler on the
web? like using a forminfo.asp where that file exist in a forms folder>
<!--#INCLUDE FILE="Forum/default.asp
"-->
doesnt work.. <!--#INCLUDE FILE="../Forum/default.asp
"-->
doesnt work <!--#INCLUDE FILE="http://my...more >>
ASP / ADO Recordset field binding Posted by Lluis O at 6/11/2004 5:19:46 PM We have an externally developed application, that runs on a W2K IIS 5 (
sp4 ) Server, and are very unhappy with the performance, as our users are
getting very very bad response times from the IIS Server, not being a
conceptually complicated / big application at all.
I'm very new in the IIS / A...more >>
Load Testing File Uploads Posted by Scott at 6/11/2004 1:47:01 PM I am installing a new feature on our application that will allow the user to upload small to medium files from the web. I am using a pure script solution for the upload logic and storing the information in the database.
I am running some load tests for the file upload, and I am getting a high nu...more >>
INSERTing Line Breaks into MySQL DB using ASP Posted by Astra at 6/11/2004 10:52:32 AM Hi All
Could you please let me know how my ASP page can insert 1 row of data
containing line breaks into a MySQL DB.
To explain, I'm using ASP Classic > MyODBC 3.5x (Win) > MySQL 4 (Win) and my
insert command is:
INSERT INTO `WEBCONTENT` (CONTENTTEXT) VALUES ('Order Number: [ORDERNUM]
Ac...more >>
SQL Server 2000 Correlated Query Question Posted by MDW at 6/11/2004 8:56:01 AM Hey all,
Have another question. I've got a SQL Server 2000 DB that contains employee information....we've got a table called EMPLOYEE_MASTER and one called EMPLOYEE_DETAIL. The two tables are linked based on SSN.
In the EMPLOYEE_DETAIL table, there is a column called START_DATE and a column ca...more >>
Oracle and asp multiple sql statements Posted by Mike D at 6/11/2004 5:24:23 AM I have a connection between asp and oracle. I have tried
the OLE DB connection from both MS and oracle.
I can connect and do 1 insert statement but how do I do 2?
Insert Into () values ();Insert Into () Values
gives me an "ORA-00911: invalid character" error. How do
I seperate the sta...more >>
Site message Posted by +FarmerPickles at 6/10/2004 12:33:36 PM I would like to like for members to leave other members private messages on
my site. Could someone point me in the right direction for writting
something like this?
Thanks
Jeff
...more >>
Sorting With a UNION Query? Posted by MDW at 6/10/2004 8:01:49 AM Hey all,
I'm working with SQL server 2000 (upsized from MS Access 2000) and I've been able to reconcile all my SQL differences but one. I build a fairly complex recordset that consists of a UNION from two different SELECT statements. It ends up looking like this:
SELECT
Col1,
Col2...more >>
How to read an SQL Server into a ASP page and then change, add, delete and write it back to SQL Server Posted by belindacur NO[at]SPAM yahoo.com at 6/10/2004 1:20:10 AM Hello All
I need to read a SQL Server table into a Web Page and within the Web
Page to permit my users to make changes to the records, delete or add
new records and then save the entire contents back to the SQL Server
table back.
The functionality I am looking is almost the same as In the S...more >>
Could not find installable ISAM Posted by Serge Myrand at 6/9/2004 4:43:52 PM Hi,
Using this ASP code I get the error Could not find installable ISAM. I
always connect to Access databases using ADO and Delphi. I never got
this error message. I want to use ADO within ASP code what is the
problem I have? I tried with Access db 97, 2000 and 2002, always the
same message. ...more >>
Clearing a variable in a database thru ASP Posted by Rahul Chatterjee at 6/9/2004 10:59:05 AM Hello All
I have a website which has login and logoff features. When some one logs in,
I set a variable in the database to 1 and if he logs off, I set it to 0.
This is fine as long as the user actually clicks the button. If the user
were to just close down the browser, the variable would never...more >>
Storing and Retrieving Info in Access Posted by erikthenomad NO[at]SPAM hotmail.com at 6/9/2004 10:27:32 AM I'm not sure if this is even the best place to ask this question, but
here goes: my site is hosted by a third party on a Win2K platform and
there is a SQL server on it. What I'd like is to be able to create a
"Wish List" of sorts on the site, whereby the user enters info on
products they want,...more >>
PLEASE HELP. Access to db locked. Posted by Carlos Sol at 6/9/2004 10:18:41 AM Good day
I am having a problem developing a web application for an
on line catalog. I
am using ms access XP on an XP professional platfrom. I
have been able to
succesfully develop a web page to query the database to
produce a list of
items in groups of 10, but when I request the next 10
it...more >>
Best connection string to connect to SQL dbase... Posted by Mike Hill at 6/9/2004 9:38:46 AM I need to connect to a dbase. I will be using ASP.NET, Windows 2003 Server,
and SQL 2000. What would the best connection method be:
OLE DB :
<%
Set cnn = Server.CreateObject("ADODB.Connection")
cnn.open "PROVIDER=SQLOLEDB;DATA
SOURCE=sqlservername;UID=username;PWD=password;DATABASE=mydatabas...more >>
Forgot Passwprd Posted by +FarmerPickles at 6/8/2004 5:42:15 PM Can someone point me in the right direction for getting script that emails a
user their PW from a DB that is already in use? It is access DB and uses asp
scripting. Let me know if you need anymore info.
thanks all
Bammer
...more >>
Detecting the lenght of a MEMO field retrieved from a SQL database Posted by Ken Lomax at 6/8/2004 2:27:21 AM Hi
using VBScript, SQL, ASP I would like to show the contents of a memo
field but only if it is not empty. I can do this with regular text
fields, but not a memo field. So something like:
sCommand = "SELECT aMemoField FROM aTable"
set sDetails=conn.execute(scommand)
if sDetails(0)<>"" then...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |