all groups > inetserver asp db > june 2007
ASP button to Execute Stored proc in table Adapter
Posted by Datasort at 6/26/2007 10:33:02 AM
Is it possible to add a stored proc to a table adapter and execute the proc
inside an ASP button click event?
I have a table adapter called Claimers and a sp called AddWatch. On the
onclick event I would like to call the table adapter and execute the sp.
Note that the sp does not return re... more >>
Recordset Paging - Not Showing records on next page
Posted by AnxietyAnswers at 6/26/2007 1:39:18 AM
When I use the next button no records show up on the next page...
I've been going over this for half a day and can't figure it out. Any
help would be greatly appreciated!
<%@ Language=VBScript%>
<%Option Explicit%>
<%Response.Expires=0%>
<!--#include file = "adovbs.inc"-->
<%
Const intPag... more >>
Error with SQL
Posted by J-P-W at 6/19/2007 4:00:31 PM
Hi,
I have:
strsql = "SELECT * FROM tblTheCustomers WHERE CustomerID=" &
session("CustomerID") & ";"
response.Write(strsql)
Response.End()
The browser shows:
SELECT * FROM tblTheCustomers WHERE CustomerID=1;
Great!
When I remove the two response. 's I get:
Error Type:
Micros... more >>
Working with Sessions for functions
Posted by Chen Leikehmacher at 6/19/2007 2:05:10 AM
I have a problem.
I'm having on my site a Session by the name "UserLogon"
which will either have values "true" or "false".
I want to use that information with a function so I will be able to make an
image be visible or not.
However i don't think that it is possible to have asp codes inside <sc... more >>
Commenting in Sql
Posted by shiv.shankar.dr NO[at]SPAM gmail.com at 6/18/2007 4:57:01 AM
I am using Adodb in Vb6 and Access 2000
i want to know how i can have some text commented with in Sql
statement,
... more >>
ASP Database error
Posted by Chen Leikehmacher at 6/16/2007 2:36:06 PM
Hi.
I'm currently working on a project for highschool and I'm creating a
website. I am currently on the works of achieving connection to the database
but I seem to get an error everytime I try to run the ASP. Here is the
error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[M... more >>
Need help building query
Posted by Adrienne Boswell at 6/15/2007 12:00:00 AM
Using Access and ASP (going to migrate to something more robust when this
is cleaned up):
Given the following information (I know that one card has been assigned
three times)
ID Card Number M_id Added
602 8888177601005601 2 2005-04-11 00:00:00
5101 8888177601005601 11 2006-05-31 0... more >>
Data source name not found and no default driver specified
Posted by rabblerowzer NO[at]SPAM yahoo.com at 6/5/2007 4:33:20 PM
Hi, I have IIS and SQL Server2K on the same machine where I am trying
to get an ASP file to return data. I can not get past this one error
though:
ERROR MESSAGE:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no
d... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Two queries versus one combined query
Posted by Adrienne Boswell at 6/5/2007 1:45:15 PM
I have a classic asp page that lists products. Right now, there is
one query to get the list of products (from a product view), and then
another query to get the individual merchant's information (from a
vendor view). I am thinking that using one query for both is going to
save some server tim... more >>
Login failed for user '(null)'.
Posted by ShadowVixen at 6/5/2007 5:43:01 AM
Getting the following error when attempting to access my web app from a
machine other than my local machine (housing the IIS server).
Error Type:
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection.
... more >>
|