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



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


DevelopmentNow Blog