|
|
|
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 |
Filter by week: 1 2 3 4 5 Am I asking in the wrong way or something - no responses! Posted by Mike Williams at 10/7/2004 6:27:46 AM Am I doing something incorrect in regards to asking for
help. I tried to give database samples, query samples,
data samples, etc. Please let me know the most effective
way to provide you with information....more >>
ASP error - HTMLEncode Posted by A-Face at 10/7/2004 5:40:47 AM Hey guys
I had an error that I managed to sort out the other day.
Even though it was an error on my part, thanx to those who
gave me suggestions. However, now I have a new prob.
I'm trying to access fields in an ADO recordset on Win
2000 Professional and IIS 5.0. I've managed to debug a ...more >>
Pluses and Minuses of using Response.Buffer = True Posted by Laphan at 10/6/2004 9:37:31 PM Hi All
Could somebody outline what are the pluses and minuses of using
Response.Buffer = True at the top of my ASP pages.
I was told by a poster a long time ago that using this command if you can
get away with it gives a better output (?!?!?), but I never found out what
he meant by getting ...more >>
Show Hide with ASP Posted by C White at 10/6/2004 4:53:37 PM Hi All
It's been several years since I've done any ASP programming and I've
recently been thrown back into it so I am very rusty, to say the least.
I use a javascript, in regular html, you click on the link and it
displays more information below:
<!--
function openIt(FAQ) {
showI...more >>
iSeries DB Access from ASP Posted by Brian Piotrowski at 10/6/2004 12:35:01 PM Hi all,
Would anyone happen to have a DSN-less block of code for accessing a DB2
database on an iSeries (AS/400) server? I need to access some information
on it, but I'm having some trouble writing (or even finding) code for a
connection.
If not, is there a way I can access the DB in MS SQ...more >>
Access Posted by Paul Smith at 10/6/2004 11:53:17 AM If you are using an access database, is it possible to create a recordset
from a query stored in the db, rather than from a SQL string?
...more >>
Tutor Project - more Posted by Mike Williams at 10/6/2004 7:47:20 AM What I am developing is a system to match Tutors and
Tutees based on Interest, Days, and Time. I'm having
trouble matching the two based on Interest and Time and
Days. I finally have most of the foundation laid. Here
is what I have:
----------start of database layout and sample data --...more >>
Need help with ASP/VB Code. Posted by akasotia NO[at]SPAM guidemail.com at 10/6/2004 7:32:00 AM Problem: I keep getting the error which says" Description: Either BOF
or EOF is True, or the current record has been deleted; the operation
requested by the application requires a current record. Source:
ADODB.Field - clsName.ValidateAgent" --- This messsage is repeated 4
times. What follows bel...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
invalid object name after upsize Posted by Dan Nash at 10/6/2004 3:37:01 AM Hi guys
I've just upsized my database from Access 2003 to SQL Server, and uploaded
it to my webhost. They setup the database for me, and I've changed the
connection string.
However, I'm getting the following error...
[Microsoft][ODBC SQL Server Driver][SQL Server] Invalid object name 'p...more >>
programmatically create views Posted by Bryan Harrington at 10/5/2004 7:11:37 PM Hello all.. just trying to flush something out here, please let me know if
I'm way off here.
The application I'm working on has a queue of items to be worked on, and
users will be assigned to user groups which will filter that queue by any
combination of up to 8 items (Location, category, etc....more >>
Parse Excel file using ASP Posted by amorous at 10/5/2004 4:22:25 PM Hello All,
I have below piece of code:
******************************
<%
Option Explicit
Dim objWinHttp
Dim strHTML
Set objWinHttp = Server.CreateObject("WinHttp.WinHttpRequest.5.1")
objWinHttp.Open "GET", "http://XXX.XXX.XX/test1.XLS", false
objWinHttp.SetCredentials "username"...more >>
help getting debugger to work with my ASP Posted by mgm at 10/5/2004 9:09:03 AM Can anyone direct me on how to get MS Script debugger to work with my ASP
code or could you direct me to a website that explains it.
Any help would be greatly appreciated,
Thanks - mgm...more >>
First attempt at db (All replies gratefully received) Posted by ted at 10/4/2004 11:50:34 PM I want to attach a small db to a site I designed in FrontPage 2003. I'm sure
once this is done I will need to connect that db to another, releated one. I
am using XP Pro with a Win 2000 Server.
The first one is allow a visitor, once the transaction is complete, to leave
comments about a par...more >>
MULTIPLE TABLE QUERY! Posted by Anthony Judd at 10/4/2004 6:03:33 PM I am trying to retrieve data based on data in three tables.
Not quite sure how to proceed.
//Logic
// retreve cost item data, category_name assocociated with
cost_item.category_id in category table where category_id is associated with
category_group.category_group_id = 3
SELECT...more >>
Cannot connect database Posted by A-Face at 10/3/2004 4:20:28 PM Hi
I trying some pretty basic web-enabled database stuff but
I can't seem to get past the first hurdle.
Tools - Windows 2000 professional
- IIS 5.0
- Microsoft Access 2000
- Microsoft FrontPage 2000
I've created a new ASP file and added code to read the...more >>
Newbee need help. Posted by Erik .F at 10/3/2004 10:18:34 AM I am new to ASP and i am having some dificulities here and there.
I can not get the following code to wor like i want it to. I do not get
any messages that says that is something wrong bot there is no data from
the DB(ACCESS) displayed in the selectbox.
Wold be very gratefull if someone coul...more >>
Picture Sizes Posted by Popeye at 10/2/2004 7:14:47 PM I have an asp page that retrieves various details from and Access table. One
of the columns stores an image name and is written into the html as follows:
Response.Write "<td width=200 height=200 valign=top><img border=0
src=../../gallery/" & rec1("picture") & "></td>"
The image loads fine ...more >>
Creating a comma delimited list Posted by fianna_sidhe NO[at]SPAM hotmail.com at 10/2/2004 6:53:41 PM Hi all,
I have a table full of widgets. Each widget has its own detail page. I
want a list page for the widgets where each widget is listed seperated
by a comma. So my results will look like:
Widget1, Widget2, Widget3, Widget 4 etc.
I am having a huge problem getting this do output th...more >>
ASP Stored Procedure! Posted by Anthony Judd at 10/2/2004 4:32:27 PM
CREATE PROCEDURE get_event_list
@order_column VARCHAR(15) = null
AS
BEGIN
Using a stored procedure to return recordset of rows.
SELECT event_id,event_code,event_topic,event_category FROM event
ORDER BY CASE WHEN @order_column = 'event_id' THEN event_id
WHEN @order_c...more >>
Need Help with SQL syntax error Posted by westernnord NO[at]SPAM webtv.net at 10/2/2004 10:34:09 AM I get the following error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.
/sds-test/manageproducts.asp, line 79
I have displayed the sqlStr with Response.Write sqlStr with the following
r...more >>
Global asa Versus #include Posted by Anthony Judd at 10/2/2004 9:45:07 AM Hi guys,
Which do you prefer when storing a db connection string for an application.
Place it in a global.asa file or have it in a include file.
I have been using both for some time...just wondering what everyone else
does!!
AJ
...more >>
Connecting network DB (SQL) through windows integrated auth. in AS Posted by windows integrated authentication at 10/2/2004 12:45:04 AM We have an ASP application that connects to SQL server through SQL
Authentication.
Now we want to use windows integrated authentication for security reasons.
We have the following constrains:
1. Don't use Anonymous Access & Basic Authentication to the ASP Application.
2. SQL server is ...more >>
ASP SQLSERVER PROB: Posted by Anthony Judd at 10/1/2004 11:06:38 PM When i try to insert a record into a table 'account' i keep getting this
error..
Microsoft OLE DB Provider for SQL Server (0x80040E37)
Invalid object name 'account'.
It doesn't occur when i issue the select statement..results are returned.
cst = "Provider=SQLOLEDB;Data Source=127.0.0.1;I...more >>
Getting the new record's AutoNumber Posted by Darren Heinrich at 10/1/2004 5:37:40 PM Damn!
Again a piece of working code from another page of mine is not working when
I use it elsewhere...
The code below is not giving me the new records Autonumber. When I look at
the raw data in Access the Autonumber is from the first record!
I'm using recSet2.CursorLocation = adUseClient to ...more >>
Newbie... executing code when a button is clicked... Posted by Brad Pears at 10/1/2004 4:17:33 PM Hello there...
I am completely new to ASP and web programming. We have a small project
going on and somehow I am getting involved. I use Access and VB so have
programming experience.
To learn a bit about ASP, I downloaded a product which auto generated a
bunch of ASP pages for me which open...more >>
strange checkbox yes/no field problem Posted by Darren Heinrich at 10/1/2004 12:21:36 PM Hi,
I'm getting an error updating an Access record that has a YES/No Field.
If I leave the checkbox unchecked I get this error:
Error Type:
Provider (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done.
Strange thin...more >>
Password Storing Standard Posted by Kit Truong at 10/1/2004 11:20:32 AM Hello,
When I'm creating database driven asp applications, I store my constants,
including my connection string to the database within an asp file called
constants.asp. All constants are stored inside asp coding <% ... %> so
people can't save the data through the web.
I've been told this...more >>
Stored Procedured doesn't return recordset in asp Posted by piotr at 10/1/2004 9:53:52 AM Hi,
I created simple Stoed Procedure:
CREATE PROC my_proc @id INT, @name VARCHAR(50)
AS
INSERT INTO names (Id, Name) VALUES (@id, @name)
SELECT @@IDENTITY AS lastid
Then I run it with simple code:
EXEC my_proc 24, 'KSSWD'
Now, when I run it using OSQL everything is OK, it returns one...more >>
RecordSet without actual data behind it Posted by Agoston Bejo at 10/1/2004 9:39:27 AM I would like to use an ADODB.RecordSet object to temporarily store some data
and then iterate through it. Actually it needs to be a RecordSet only
because it is a perfect choice as data structure for what I want to do, I
don't want to actually run queries or update tables with it.
It seems to me...more >>
Tutor and Tutees website system Posted by Mike Williams at 10/1/2004 7:47:45 AM I'm starting to develop a system to link Tutors with
Tutees. The goal is to match tutors with tutees on their
likes and schedule (MTWRFSU, morning, afternoon, and
evening)
Below is the proposed database schema for the tables.
Could you please let me know if you think it would work
for...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |