| Groups | Blog | Home |
|
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 |
ADODB Trace transaction Posted by HEGMS at 4/30/2007 1:18:00 AM Hi,
I need to tune up an application and I'd like to enable sql tracing to see
how query are made.
I've search around to see how I can do but I've find nothing.
I'm using adodb object with a connection string to connect to my sqlserver.
...more >>
Change access table description Posted by Giles at 4/28/2007 12:00:00 AM I have an Access DB where the table names are not helpful (e.g."ph"), but
the DESCRIPTION is friendly (e.g. "Public Health").
The descriptions have been put in by directly editing the Access interface
and right-clicking the table, selecting "Properties", and entering text into
the "Descriptio...more >>
SQL doesn't work in ASP but does in Access Query Posted by Andrew Virnuls at 4/27/2007 3:00:38 PM Hello all!
I was wondering whether anyone could shed any light on why my SQL update
query works when run in an Access query, but doesn't work on the same
database when run through ASP and ODBC.
Here's the code:
UPDATE tbl_events SET tbl_events.description = 'Meeting - Teaching and
Lea...more >>
Tool for converting Access Queries & Forms to ASP for Web ? Posted by MyEmailList NO[at]SPAM gmail.com at 4/25/2007 7:09:32 AM Is there a tool for converting Microsoft Access Queries & Forms to
ASP
so you can put it on the web?
We have an Access database with a half dozen tables, plus a number of
queries and forms.
Some of the forms have sub-forms and are quite complicated.
Must we create all these queries and F...more >>
ACCESS AN ACCESS DATABASE FROM ASP.NET INTRANET SCENARIO Posted by BITS error code -2147024891 or 0x8007000 at 4/24/2007 10:08:02 AM I'm trying to access an access database on the file server from a web server
using asp.net and IIS 6.0. I can do it when I have anonymous access enabled
in IIS 6.0 as in the public internet web site style. I want to do the same
with the intranet setup where IIS 6.0 is not setup to allow anon...more >>
Parse string from field CORRECT EMAIL Posted by Dan Somdahl at 4/19/2007 1:36:48 PM Hi, I am new to ASP but have what should be a fairly simple task that I
can't figure out.
I need to parse a string from a single, semi-colon delimited, 60 character
field (el_text) in a recordset and display the results in a table on a
webpage (ASP)
I can retrieve the recordset from the datab...more >>
Parse a string from a field and put in table on webpage Posted by Dan Somdahl at 4/19/2007 1:24:10 PM Hi, I am new to ASP but have what should be a fairly simple task that I
can't figure out.
I need to parse a string from a single, semi-colon delimited, 60 character
field (el_text) in a recordset and display the results in a table on a
webpage (ASP)
I can retrieve the recordset from the datab...more >>
Parse a string from a field Posted by Dan Somdahl at 4/19/2007 1:17:24 PM Hi, I am new to ASP but have what should be a fairly simple task that I
can't figure out.
I need to parse a string from a single, semi-colon delimited, 60 character
field (el_text) in a recordset and display the results in a table on a
webpage (ASP)
I can retrieve the recordset from the datab...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Sql Not Properly Ended Error -Solved Posted by shall NO[at]SPAM uaex.edu at 4/18/2007 7:47:34 AM I was getting the error
[Oracle][ODBC][Ora]ORA-00933: SQL command not properly ended
For me, I had in my ASP page reading from an oracle table:
Select TT.myfield
>From mytable AS TT
It should have been without the "AS":
Select TT.myfield
>From mytable TT
I hope this helps someon...more >>
Getting data from XML file to an array/db Posted by Newbie at 4/16/2007 12:00:00 AM Hi All
Wondered if you could help.
I have created a little backup routine (using classic ASP and ADO) to get my
data from my db into a bespoke XML file, ie I query the data into a
recordset, concat the XML tags with this data and then put it into a text
file using FileSysObj.
This backup...more >>
Need ASP help!!!! Posted by Rae Kim at 4/14/2007 8:13:58 AM Hi,
I am trying to use ASP in html to retrieve and display data from an MS
Access database. I keep getting this error:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'PersonID='.
In relation to the following line of code in ASP:
str...more >>
HELP! -- Redirection question Posted by segis bata at 4/13/2007 7:52:00 PM Hello all,
I have a page (located at mywebsite/a.asp) that redirects to another page
(theirwebsite/b.asp) located in other server. This other page probably will
redirect to another link again (othersite/c.asp) and finally display the web
page I want the user to see (finalwebsite/d.asp)
...more >>
Insert SQL to Parent and Child Tables Posted by PinkBishop at 4/12/2007 10:16:59 AM Can somebody direct me on proper syntax of SQL statement to insert
into one table that has child table in a relational database?
I can get the insert to work for the Parent, but a record also needs
to be inserted into the Child. Below is an example of my tables. I
get Table 1 to insert no p...more >>
DIVIDE BY ZERO ERROR, WHEN RUN FROM ASP PAGE Posted by norrisinc at 4/12/2007 8:05:03 AM Here is the scenario, i have a stored procedure, it calculates
commissions and runs fine in SQL. However when the SP is run through
my asp page it will come back with a divide by zero error, but only
for one sales person... I have been through this code a hundred times
and can't find any error...more >>
Insert Records Posted by Mike Will via WebmasterKB.com at 4/9/2007 8:17:38 PM Hello! I'm having some trouble adding new records to my database. It just
won't do it. Please take a look and let me know if there are any ideas.
<%
mystring=request.form("employee")
Arremp=split(mystring, ",")
'Response.write Arremp ((0))
set conn=Server.CreateObject("ADODB.Con...more >>
simple insert statement Posted by Billy Barth at 4/6/2007 12:29:06 PM I can't seem to get this to work right.
Here's my page Code.
<form id="FormName" action="news_enter.asp" method="post" name="FormName">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="3">
<div align="center">
<strong><font size="3" c...more >>
Removing obscure chars Posted by Yobbo at 4/3/2007 6:17:59 PM Hi All
I have an ASP function in place to strip invalid chars out of a data store
before I create an XML file of this data, but my function doesn't work on a
certain set of chars.
As far as I can see these are the following:
a) trademark char
b) long hyphen/dash char
c) smart/curly quot...more >>
whats my DSN.........help me Posted by mehdi.webmaster NO[at]SPAM gmail.com at 4/1/2007 1:29:29 PM hi.whats my dsn. i dont know.please help me.thankx
ConnString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" &
Server.MapPath("db/mem.mdb")
set my_conn= Server.CreateObject("ADODB.Connection")
RS.open Sql,my_conn,1,3
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |