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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|