|
|
|
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 Join Posted by Maarten at 10/31/2004 6:01:56 AM
table 1 (tblClubs)
fields: clCode - clName
111 The Frogs
222 Easy riders
333 The butterflies
table 2 (tblCalendar)
fields: calDate - calHomeCode - calVisitorsCode
9/9/04 - 111 - 222
15/9/04 - 222 - 333
How to retrieve the name of the home playing club aswell as the name o...more >>
fasterr than RecordCount? Posted by Mich at 10/30/2004 12:18:15 PM Hi,
I often need the number of records in a recodset.I use RecordCount, but is
there no faster way, because sometimes, it takes a while.
Thanks
Mich
...more >>
Help with Line-break Posted by Sam A Ruos at 10/30/2004 9:35:15 AM Does one need to code a Function to insert line-breaks to display data (txt)
that consists of more than 1000 characters?
The problem I'm having right now is, that in the displaying-tabel (HTML)
displays one long line of text which I have to scroll right (horizontally)
even though I assigned th...more >>
please help with the newbie error - connecting to the DB (ASP.NET Posted by kostyantyn_salimov at 10/30/2004 4:29:01 AM I've the following simple page:
===
<%@ Page Language="C#" Debug="true" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<script language="C#" runat="server">
void Page_Load(Object sender, EventArgs e)
{
SqlConnec...more >>
Edit or Delete records Posted by Rajani at 10/29/2004 7:45:02 PM Hi,
I have two tables and both are referenced. I want to perform Edit/Delete.
I am displaying all the record in table format.
checkbox rollno batchno color_code(select control) qty
The user will check the checkbox to edit/delete the corr record. Rollno,
batchno, qty are textbox...more >>
Hosted site craching DB layer (SQL Server does not exist or access denied) Posted by rburr49 NO[at]SPAM hotmail.com at 10/29/2004 12:01:24 PM I'm having mega problems with a large database-driven site that's
hosted on a reputable ISP's W2K webserver and SQL2K database server.
It seems for some while it's been causing them problems (unknown to
us) with connectivity between the webserver and db server. When the
problem occurs the hosted...more >>
Automatic update of combo2 triggered by on change event of combo1 on web page Anyone got a simple example? Posted by richard NO[at]SPAM dingydangy.it at 10/29/2004 9:26:16 AM Hi!
I need to do something that seemed simple in ASP : an automatic update of
combo2 triggered by on change event of combo1 on same form on a web page.
NOT that easy I begin to think.
Anyone got a simple example?
Thanks
Richard...more >>
join on 3 tables for asp output Posted by Mike D at 10/29/2004 8:05:05 AM I have three tables. The table structure and sample data is below(sorry for
the length). I want a select that will retrieve all Mondays since I am
scheduling instruments for a whole week. Every Instrument should have a row
for every Monday that way I can show that it hasn't been scheduled. ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
ASP page linking field s to 2 different dB,s How?? Posted by b NO[at]SPAM b.net at 10/29/2004 1:40:19 AM I have a page that displays a table with several fields/columns....one
of the fields is populated with a a 9 digit # (each one is different)
Each of these #'s relate to another field (and the records are all
different here as well) in a different dB.
I want to make each of the #'s in the 1st p...more >>
Retriving data from DB Posted by Neven Klofutar at 10/28/2004 12:44:09 PM Hi,
Is it possible to retrive data from Recordset using this syntax
rsRecordset("t_Person.s_Name")
insted of
rsRecordset("s_Name")
thanx, Neven
...more >>
Login - How secure and is it a standard among you all Posted by James at 10/28/2004 10:54:00 AM Currently , I allow users to login from a log in screen
then I check it against a database. Once record is found,
then I set a session variable (Authenticated = 1). Then
throughout the website if that session variable is present
then they can get in the administrative pages.
My questi...more >>
Error: Unable to Load SQL OLEDB provider resource dll. The application cannot continue. Posted by Drew at 10/28/2004 10:05:59 AM I am getting this error while developing ASP code for an app. It seems to
be doing this if I try to insert a record that is already in the DB. I am
using IE 6 and it just hangs when this happens, I have to close and reopen
the browser to work any longer. The problem is that this error message ...more >>
I am lost, multiple tables to one recordset. Posted by anniesraar NO[at]SPAM hotmail.com at 10/28/2004 9:27:34 AM Hi,
I am completely lost. I have a stored procedure that creates a temp
table and inserts and eventid. Afterwards other fields are gathered
via an innerjoin. The problem is that I have a created another table
with only the changes to these events.
So
tblEvent is eventid / eventname / even...more >>
triggers for UPDATE Posted by ben h at 10/27/2004 3:54:07 PM I can't quite work this out: SQL server trigger for update, and I
specify a single column e.g. IF UPDATE ( statusCode ), does it return
true if the old value and the new value are the same?
Specifically, I use execute method of ADODB.Connection object, and issue
an update table statement, b...more >>
superimposing a pic on a pic when the data is dynamic Posted by Astra at 10/27/2004 2:08:24 PM Hi All
I know the subject may sound weird so hopefully the below will explain.
1) I'm creating an estate agent web site, which will display a 1 x jpg pic
and say 4 text descriptions for each property from a DB using ASP .
2) Another aspect of shall we say the property's properties is that ...more >>
Is there NO ONE that can help with this error? Posted by gm at 10/27/2004 12:58:02 PM This is a repost... starting to feel invisible here... does no one know?
How do you get a web app to not show the 'page has expired...' error and
refresh and requery when you hit the back button after submitting a form? I
just want the old data to still be displayed in the form so the user can...more >>
Databases connections not working more with all web sites Posted by Andrew Zamkovoy at 10/26/2004 3:48:47 PM Hello World,
MS NT 2000 Server (+with all latest SP).
asp.dll version: 5.0.2195.6672
jet.dll version: 5.0.2134.1
All usually working before well, but accidentally crashed by undetermined
reason:
Databases connections, both, for MS SQL Server 2000 (SP1) and MS Access 2000
databases stop ...more >>
cannot find procedure which is available when implemented the application in windows 2003 Posted by ksaran_an NO[at]SPAM yahoo.co.in at 10/26/2004 2:49:43 PM Hi Guys,
Hope you can help me out.
from the web server the procedures are not able to access through the
dll method written by vb. it's working just fine when we are in
windows 2000 server. recently we implemented our application to
windows 2003. everything works fine except the methods can...more >>
Managing locations Posted by Astra at 10/26/2004 12:18:19 PM Hi All
I know this is a strange request, but I currently creating an estate agent
type site and I noticed on somebody else's (big company - not interested in
little old me!!) that they give the user the option to see property results
that are 2, 5, 10 miles, etc away from the location that I c...more >>
Access ASP newbie help Posted by ck1web NO[at]SPAM yahoo.co.uk at 10/26/2004 11:30:10 AM Hi
I would appreciate advice concerning what I need to learn to develop a
web based database which I need to create as part of my computer
course.
The database should be fully web based, it should allow members of a
club to subscribe to various groups and will enable group leaders to
send ...more >>
Concern with using Stored Procedure with ASP Posted by skirkby at 10/26/2004 2:49:11 AM You'll excuse what may be an obvious question...
I have an ASP application that needs to use a stored procedure in order to
access Joined databases on SQL2000. I have found some examples of how this
can be done on MSDN, but what I can't find is how to ensure error free
operation.
From th...more >>
Insert into middle Posted by Rajani at 10/26/2004 12:33:03 AM Hello,
I am inserting data to two table from ASP (both are referenced). The data
in the second table must be inserted as per the order i entered(atually same
order mentioned on the paper). Everything is ok. If i forgot to enter 3rd
record, the total output will be wrong. I can enter sepe...more >>
Updating DateTime? Posted by jason NO[at]SPAM catamaranco.com at 10/25/2004 9:35:09 AM Help! How does one UPDATE date and time field in Sql server:
Eg: u_ExpiryDate = 8/25/2004 3:40:48
If I try this:
UPDATE t_user
SET u_ExpiryDate = 8/25/2004 3:40:48
WHERE u_ID > 1
I pick up an error.
Appreciate replies
Thanks
Jason
...more >>
Beginner asp tutorial required + dreamweaver or FP Posted by ck1web NO[at]SPAM yahoo.co.uk at 10/25/2004 6:29:18 AM Hi
I have reasonable experience with access. I am just about to start a
web based database project for my computer course.
I have very very limited experience of frontpage, VB & VB script, I
have no experience of ASP or dreamweaver.
I have office xp pro and am in the process of buying and...more >>
Access Database Update Posted by Erica at 10/24/2004 11:29:01 PM I have a poll script on my site. When someone votes I am trying to add one to
the existing number of votes in the poll table for whatever answer they
choose. The number is not writing to the database. I don't get any errors,
the value just does not get written to the database for some reason. ...more >>
ASP send mail problem Posted by westernnord NO[at]SPAM webtv.net at 10/24/2004 9:00:08 PM I am using Windows XP with IIS to send email. My ASP page sends the email OK
because it goes from the Pickup folder to the Queue folder. However, the
mail just sits there and is not picked up by my ISP. I can open the .EML
file in Outlook and it looks fine. Do I have a configuration problem or...more >>
how to pass an array of data with hidden fields or cookies? Posted by Fred at 10/24/2004 9:57:17 AM Hi,
i know how to pass a value from Javascript to ASP with a hidden field into a
form and submitting it, or with cookies, but here i have to pass a lot of
data in an array.
There is a list of product the visitor can order by clicking one or more
checkboxes. I made a form containing input wi...more >>
How to create connection pool in asp?? Posted by Utada P.W. SIU at 10/20/2004 2:16:41 PM Thanks a look~
...more >>
results page not filtering on date Posted by Raymond Keattch at 10/19/2004 2:58:17 PM Microsoft Access backend database.
I am trying to filter a recordeset on several criteria, including dates.
The page works but the data is never filtered on date. Here is the code
in the results page
strWhere="WHERE"
strOrderBy = " ORDER BY"
if (request.form("chkSorting")="date") then
...more >>
viewing contents of field type "long text" Posted by Paul Thakur at 10/18/2004 8:00:30 PM I am writing vbscript code in an .asp page. I need to display field values
from a sql table consisting of several fields, one of them is of type "Long
Text". This field contains XML data. I like to be able to assign vale of
this field to a variable, display it and write out a text file using file...more >>
viewing contents of field tyep "Long Text" Posted by Paul Thakur at 10/18/2004 7:57:32 PM I am writing vbscript code in an .asp page. I need to display field values
from a sql table consisting of several fields, one of them is of type "Long
Text". This field contains XML data. I like to be able to assign vale of
this field to a variable, display it and write out a text file using file...more >>
ASP to DB to FDF to PDF Posted by H8ids at 10/18/2004 3:48:51 PM Working on an online submission form which needs the ability to print the
submitted information from a PDF document. The document has to be generated
on the fly and have the option of opening or saving.
Can this be achieved with ASP and Microsoft Access?
...more >>
network drive and MSWC.nextlink Posted by Kanan at 10/18/2004 11:55:02 AM hi,
Is it possible to access a file from network drive in ASP? Second question is,
How is it possible to use GetNthURL to access this file in the network drive?
I would appreciate if somebody has any example on using this feature.
thanks
Kanan...more >>
database connections in ASP Posted by evandelagrammaticas NO[at]SPAM hotmail.com at 10/18/2004 6:25:25 AM Hi guys... I am developing an application and need some advice while
the application is still in its infancy.
1. Set Conn = Server.CreateObject("ADODB.Connection")
2. Conn = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" &
Server.MapPath("documents.mdb")
3. Set rs = Server.CreateObject("ADOD...more >>
SQL Error - not retrieving any record Posted by westernnord NO[at]SPAM webtv.net at 10/17/2004 5:37:30 PM I am getting the following error:
Error Type:
ADODB.Field (0x80020009)
Either BOF or EOF is True, or the current record has been deleted. Requested
operation requires a current record.
/sds-test/admin.asp
Here is the code:
sqlString = "SELECT current_weekday, " &_
"current_open_time, ...more >>
Stored Procedure & Quotes! Posted by Anthony Judd at 10/17/2004 10:57:26 AM I have a log in stored procedure. If some one was to enter a word containing
an apostrophe, i understandably get an error.
So i did the typical replace one quote with two. With standard sql
statements this often is the remedy.
In this case however i am still getting a syntax error. How do i deal...more >>
Sports DB Posted by Whodat at 10/15/2004 6:48:13 PM am new to dynamic web design and am having some trouble designing a db/web
form for a hockey team. I am hoping to have a form that will update the
records for each player on the team.
I have created a table in my DB with the following column headers:
playerid (primary, autonumber)
playernam...more >>
Form: extract VALUE and DISPLAY value? Posted by jason NO[at]SPAM catamaranco.com at 10/15/2004 3:29:55 PM What is the best way to extract incoming ID form variables and their
corresponding text values.
Is there an easy way to extract both the initialized value on the form and
its DISPLAY value.
For instance my form element may look this:
<input type=text name="StateID" value=<%=StateID%>>Flor...more >>
How to make link table Posted by M.Miura at 10/14/2004 5:40:37 PM for example;
There two MDBs in two different directories;
| - \dir1\data1.mdb
-\db-|
| - \dir2\data2.mdb
then if I would like to create link table, like 'tbl01', in data2.mdb
linking to the same named table in data1.mdb, how can I make
this? I mean how to code in ASP?
Any...more >>
update problem Posted by xarrisx at 10/13/2004 10:50:57 PM I am using an Insert command in my asp code that Inserts a rows in my
database.
After the Insert command i create a recordset and ask for all the rows in
the table that i aplied the insert command
Some times the rows i get are correct but sometimes the database is not
updated by the time the re...more >>
Problem on querying Access link table in ASP page Posted by tabonni NO[at]SPAM yahoo.com at 10/13/2004 6:48:30 PM Hi All
I connected MS Exchange Server to MS Access database using Access link
table function. I can open the database table and see the fields and
data inside the link table. However, the table seems cannot be queried
by SQL statement.
My situation is:
I'm building an intranet. I have a AS...more >>
Question Not Answered - XML Data that brings up "SAVE/RUN" prompt Posted by John Kotuby at 10/13/2004 12:45:15 PM It must have been a dumb question, because nobody has bothered to answer. I
am trying to send a stream of XML data to the response object and have the
user at the IE Browser end be prompted to Save or Run the file. See question
posted 10/08. I have tried adding Header info such as
Response....more >>
SQL query/datetime help: grabbing all results regardless of datetime form Posted by kenfine NO[at]SPAM u.washington.edu at 10/13/2004 8:31:47 AM I need some help with a SQL query that's intended to grab results for events
that start in the current day. I have two fields that define the start and
the end of the event called Eve_StartDateTime and Eve_EndDateTime. They
store dates and times using the standard datetime datatype.
The part t...more >>
I have no clue what's wrong Posted by westernnord NO[at]SPAM webtv.net at 10/12/2004 8:24:35 PM The code below does not assign any value to "checkpassword" no matter what
values are passed to the function. I have used Response.Write on all the
values including the "user" table values and all values are valid. I have no
clue what's wrong. Can someone provide some help?
FUNCTION checkpa...more >>
I am sure there is a better way Posted by Anthony Judd at 10/12/2004 3:02:10 PM I am comparing the values in two recordsets.
Does anyone have a beter approach!!!
Very open to suggestions on this...
Thanks...
Public Sub db_select_with_recordset(rs1,rs2,field_value,field_label,msg)
Dim found_match
found_match = false
'loop through contents of first recordset
...more >>
single quotes & double quotes in query string Posted by vasanth kumar at 10/12/2004 1:19:35 PM Hi All,
I have few text fields in my form. On submit I want to collect all the
data from the form fields and insert into a database(Microsoft Access). I
use Connection.Execute method.
This string fails, when there is a single or double quote in the string
variables. Can somebody suggest...more >>
Command Vs Connection Object Posted by wk6pack at 10/12/2004 11:36:25 AM Hi,
I was wondering which is better to use? I'm accessing two different
databases in my asp page. One thru ODBC and the other MS Jet.
Should I use a command and a connection object to connect to the two
databases?
Or should I use two connection objects?
thanks,
Will
...more >>
use a variable for -table selection- in my ASP SQL statement Posted by tghetti NO[at]SPAM targetedsupport.com at 10/12/2004 8:11:05 AM Hi All,
I have a small issue that I can't seem to figure out. I have a SQL
statement that is dependant on the results of a drop down to chose
which table to select from. Unfortunately it does not seem to work.
Could anyone point me in the right direction? Unfortunately the
datebase cannot be ch...more >>
comparing 2 "bigint" fields Posted by Dan Nash at 10/12/2004 1:57:03 AM Hi peeps
Finally upsized my database, and I've got an odd error...
The error is simply "Type Mismatch" and is occuring when I try to compare 2
"bigint" datatypes. Like this...
if table1("field") = table2("field") then
Both fields are set to BigInt in SQL Server, and I can't find anythi...more >>
Help Please, IIS, Asp, Access. Posted by milo2low NO[at]SPAM yahoo.co.uk at 10/12/2004 1:29:54 AM Hello this is Robert, from Italy,
I am trying to learn a little bit asp language,
I am tired to load pages on my web site just for test.
I installed Windows 2000 5.00-2195 Service Pack 4 + IIS 5.
Not problem to test some pages, but problem testing some others, in
particular i had problem with p...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |