all groups > inetserver asp db > september 2004 > threads for september 1 - 7, 2004
Filter by week: 1 2 3 4 5
Encryption not supported on SQL Server
Posted by Nithi Gurusamy at 9/7/2004 7:15:01 PM
I am facing this error after making changes to client configuration utility
of SQL Server 2000:
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
... more >>
syntax error in update but works fine in access
Posted by Steven Scaife at 9/7/2004 6:06:52 PM
I am getting a syntax error in my SQL statement, i have written it to the
screen and pasted into access and it runs no problems, i have also copied
the generated sql into the sql variable and tried running that and it still
falls over, cant for the life me understand why i it errors
thanks in ... more >>
Response Buffer Limit Exceeded - Ideas Please!
Posted by Brian Piotrowski at 9/7/2004 3:37:14 PM
Hi All,
I'm trying to run a simple query from an ASP page. I want the query to
select each individual field in a table and compare it to another table. If
the value doesn't exist, I want it reported. Here's the code I have to do
this check:
'Check to see if there are any assemblies not i... more >>
Exporting HTML Table to MS Word?
Posted by A P at 9/6/2004 10:00:50 AM
Is this possible? I am planning to export data from SQL that generates HTML
table. Instead of selecting the table and then copy then paste to word, I
need a script(JS or VB) that will automatically export or open the Query to
word.
... more >>
webpages and Access
Posted by Joe at 9/6/2004 9:53:15 AM
Hello,
I am a newbie with Access and have been reading the Access
Indide Out from MS and have learned quite a bit. But Where
can I learn how to make an Access DB work with an online
web page such as a search page for product on my site?
I also have a few asp password protected pages but... more >>
MSDAORA first query slow
Posted by bob at 9/5/2004 6:21:26 PM
Hi All,
I'm querying an Oracle db in asp via MSDAORA.
The connection string used is shown below,
The problem I have is the first query in a user's session take around 60
seconds. If you try again soon afterwards it is alot quicker. I'm guessing
its something to do with connection pooling? ... more >>
ASP ecommerce help
Posted by Laphan at 9/4/2004 2:32:30 PM
Hi All
I seem to be getting to grips with the whole ASP DB ecommerce thing, but
there are certain aspects that my knowledge is really thin. If poss, could
you please advise or point me in the right direction re the below:
1) I use the getrows feature all the time now for recordsets rather t... more >>
When resubmitting a long page, how do you preserve the vertical position on the page?
Posted by mike_newsgroups NO[at]SPAM yahoo.com at 9/4/2004 12:01:37 AM
Hello,
I've got a long page that resubmits itself to pass variable settings
like this:
http://localhost/hwlist2.asp?user=Kithmaker&user2=&sortby=cNumber
the problem is that when the page reloads the user starts at the top
again. Is there any way of preserving the vertical position the us... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Error Messege Help CDO.Configuration / CDO.Messege
Posted by Randy Pitkin at 9/3/2004 11:37:56 AM
From: "Randy Pitkin" <RandyPitkin@ydpages.com>
Subject: Error Messege Help CDO.Configuration / CDO.Messege
Date: Thursday, September 02, 2004 11:42 AM
Using in a ASP Application that Worked For years, Now Fails.
sch = "http://schemas.microsoft.com/cdo/configuration/"
Set objCDO = Cr... more >>
HTM Form Post into Access 2K Database - Copy/Paste causing error!
Posted by Jim in Arizona at 9/2/2004 3:50:23 PM
I'm running into an odd and difficult to track error.
This is an internal website suggestion box.
The database is an access 2000 database with a single table. the access
database has four columns for team, location, suggestion and date. The
suggestion field is a memo field. The date fiel... more >>
Any way of ordering text by its numerical values?
Posted by mike_newsgroups NO[at]SPAM yahoo.com at 9/2/2004 12:23:38 PM
Hello,
When I have a record set drawn from a text column in the database and
I do a order by, I get this:
17
18
19
2
20
Is there a way of taking numbers stored in a text column and getting
them to format in numerical order, like this:
2
17
18
19
20
???
Thanks,
Mike... more >>
adVarchar adParamOutput - size issue
Posted by Agoston Bejo at 9/1/2004 12:01:25 PM
Hi,
in Oracle 8.1.7. I've got some function like this:
PROCEDURE P(x OUT VARCHAR2)
IS
BEGIN
RETURN 'hello';
END;
Then I call it from ASP:
Dim oCmd
Set oCmd = Server.CreateObject("ADODB.Command")
With oCmd
.ActiveConnection = oMyConn
.CommandType = adCmdStoredProc
.Com... more >>
Passing Parameters in Access Queries
Posted by Gordon at 9/1/2004 10:53:55 AM
I'm sure this has been asked before, but I'm new to ASP
and haven't been able to find the answer anywhere:
I've got a query in Access that requires a parameter, the
person's name. I'm trying to run that query from my ASP
code using either a Command object or Connection object,
but can't ... more >>
data type mismatch in comparison
Posted by adnan NO[at]SPAM tridentegroup.com at 9/1/2004 7:40:57 AM
Hi,
i have a sql query that returns date parts from a specific date. looks
something like:
select datepart( d, sampledate) as "myday"
, datepart( m, sampledate) as "mymonth"
when this is inserted into my asp page, i store the returned values in
cookies:
Response.Cookies("MyDay") ... more >>
|