Groups | Blog | Home


Archived Months
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


all groups > inetserver asp db > december 2004 > threads for december 15 - 21, 2004

Filter by week: 1 2 3 4 5

how could I using ASP to retrieve a blob from Oracle 8i?
Posted by tony at 12/21/2004 10:57:52 PM
how could I using ASP to retrieve a blob from Oracle 8i? For instance: I have a table "blobtable" Field 1: customer_id number Field 2: customerphoto BLOB (all jpg) what code can retrieve the jpg file from Oracle and show it on the resulting ASP page? thanks in advance. ...more >>

ASP and ASp.NET
Posted by Wilton Yuan at 12/21/2004 2:57:30 AM
I developed an ASP application, now I want to convert it to ASP.NET. However, I cannot implement it after I completely re-design. Can I develop new things with ASP.net and keep the original ASP. Is it possible that ASP page and ASPX page run at same Web Server at the same time? Thanks in advan...more >>

Multiple html Forms & DB Inserts
Posted by Jim in Arizona at 12/20/2004 8:21:05 AM
I've got more than one form on a single ASP page. The top combo box is populated from an access database with job titles. The field below it, in its own form, is a text field that one can put a new job title into, press the submit button and add the new title to the access table which is pop...more >>

Trying to work out a join
Posted by JohnD at 12/18/2004 11:32:17 PM
Im trying to transfer an old asp/SQL server application to asp/MySQL and have run into a problem with SQL (Or suggest another news group?) My version of MySQL doesnt seem to support sub queries (and cant upgrade to the latest that does), so I cant use the existing SQL Is there any way to join w...more >>

SQL login error
Posted by Roland Hall at 12/18/2004 1:59:28 PM
I'm getting a SQL login error. Error Type: Microsoft OLE DB Provider for SQL Server (0x80040E4D) Login failed for user 'sa'. /msft/StraightASP.asp, line 7 I downloaded some files from MSFT. This one had an error, so I corrected it. The '=' was missing between Initial Catalog and PUBS. ...more >>

More time stuff
Posted by Targa at 12/18/2004 2:56:10 AM
schedcheck = "Select Sched_Date,Sched_Start,Sched_End FROM Schedule WHERE Sched_Date = #"& strSched_Date &"# AND (Sched_Start BETWEEN # "& strSched_Start &" # AND # "& dateAdd("n",-1,strSched_End) &" # OR Sched_End BETWEEN # "& dateAdd("n",1,strSched_Start) &"# AND # "& strSched_End &"#) " se...more >>

Help with SELECT Statement(Date/Time)
Posted by Targa at 12/17/2004 12:36:28 PM
Ive got a scheduling application using an Access db. Scheduling works fine but Im trying to implement a function to prevent scheduling conflicts. Im not sure if this is the way to go about it but below is what I have so far and it's not working. It schedules the event no matter what. What's w...more >>

Strange Error
Posted by H8ids at 12/16/2004 3:04:35 PM
Using ActivePDF Toolkit with a website. The site allows a user to submit information to a database, search, view and edit it. Now I want to add the option to save in PDF format after a search has been completed. Presently I have the search results populating a drop down box from which th...more >>



Order By Problems
Posted by Jim in Arizona at 12/16/2004 1:41:06 PM
I have a select field populated by a field within the table of an access database. I can't seem to have the results alphabetized. Any helpful insight, anyone? The table is called jobtitles and the field is jobtitle. <% Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "Provider=...more >>

If Request Command submitting values
Posted by Paul at 12/16/2004 5:39:59 AM
Hi all, I'm using the "If Request" command to submit data from a form to a database only when the form is submitted. But for some reason the form data is submitted to the database on page load. Causing a problem because the values submitted are null. Q1) Can anyone look at the code and tell...more >>

SET NOCOUNT ON madness
Posted by ben h at 12/15/2004 6:08:55 PM
How do i find a stored procedure or trigger that DOESN'T have SET NOCOUNT ON in it somewhere? Ben...more >>

How to determine if an ADO Recordset column is required
Posted by MyndPhlyp at 12/15/2004 4:46:22 PM
I'm having a bit of a brain cramp and need a shove in the right direction. One thing that really bogs me down is having to go back and forth trying to catch every ASP page SNAFU when the database schema gets a subtle change like making an optional column (nulls allowed) a required column (not n...more >>

Response.write statement does not work properly
Posted by Jack at 12/15/2004 3:13:02 PM
Hi, I am building a very small ASP page. I would like to check for the result of the sql statement in the page before opening the recordset. However, when I am running the page, it gives False as Response.write value of the sql statement. I have no idea why this is happening. Thanks in advance...more >>


DevelopmentNow Blog