|
|
|
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 SQL Query Posted by John Harding at 2/7/2005 4:15:58 PM Hi all,
Can anyone please spot the obviously glaring error in this SQL statement
please. Its been three years since I did SQL properly and am stuck on
this last statement for a ASP website I am doing?
string queryString = "SELECT [QH].[adults], [QH].[children],
[QH].[arrival], [HT].[star...more >>
ASP.NET and checkbox Posted by Dave at 2/7/2005 8:54:11 AM Hi all,
I'm new to ASP.NET and am working through a few exercises in a book to get
up to speed. First, some background:
I'm running SQL Server 2000 and have one field as a bit data type (0=false
or 1=true). On a form I have a check box that a user can check for whatever
reason. This f...more >>
Functions Posted by Paul Smith at 2/6/2005 9:53:56 PM Why does the first function work without a problem, but the second one does
not?
I cannot for the life of me see the difference!!!!!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Function GetTeamID(PlayerNo)
Set RSF = Server.CreateObject("ADODB.RecordSet")
RSF.Open "Select * from tPlayer...more >>
DNS less Connection with ASP Posted by dhopkins NO[at]SPAM innovativesolutions.ca at 2/6/2005 11:05:43 AM I've been using Dreamweaver MX connecting to an IIS 6 server on
win2003. I've used an MS Access DB (2000 format) If I use server DNS,
I connect to my via ASP with out a problem. However, my ISP does not
support DNS connections, so I've been trying for a few days to get a
dns less connection wo...more >>
Query problems Posted by A-Face at 2/6/2005 8:53:02 AM Hi
I am trying to run some code for my site so that when a user selects the
name of a record in the db from a drop-down on one page, an if..then
statement is applied to that record, and a result is returned. Its all gotten
me a bit confused and I think my code is now a bit of a mess.
<%
...more >>
Internationalizing a web site Posted by Tomas Eklund at 2/5/2005 7:50:03 PM Hi!
I'm in the process of internationalizing a web site with a few hundred pages.
That is, it has been available in one language and now it will be translated to
a second language. I will accomplish this by moving every text string into a
database and create an admin page where the tanslato...more >>
Correct Formatting for DB-filled textbox Posted by Laphan at 2/5/2005 1:19:37 PM Hi All
Please bare with me on my explanation as it might end up being waffle!!
In essence I have created a content management system (CMS), which uses a
lot of forms to add, update and/or remove content from a web site.
My plan was that I would give IDs to my forms so that I could do a si...more >>
Streaming media database using asp Posted by .:mmac:. at 2/5/2005 12:12:00 PM I would like to create a database of all my (200+) streaming media
files. Has anyone seen a tutorial on where a neophyte could begin with such
a specific task? I'm sure there are database tutorials out there but I would
need more specific examples for it to make sense quickly. I would prob...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Help with UPDATE statement Posted by PiGei at 2/4/2005 2:40:49 PM hello everybody,
I'm programming ASP with Access 2000 database and I can't understand
what's wrong with this SQL string:
"UPDATE tbl_count SET ( (logindate = " & "#" & Now & "#" & "),(ip = '" &
login_ip & "') ) WHERE userid = '" & x_pippo & "'"
when I'm using it with this command
SQL = "...more >>
Help with PDATE string in MS ACCESS Posted by PiGei at 2/4/2005 2:39:38 PM helo everybody,
I'm programming ASP with Access 2000 database and I can't understand
what's wrong with this SQL string:
"UPDATE tbl_count SET ( (logindate = " & "#" & Now & "#" & "),(ip = '" &
login_ip & "') ) WHERE userid = '" & x_pippo & "'"
when I'm using it with this command
SQL = "U...more >>
Query Parameter Posted by Paul Smith at 2/4/2005 12:38:53 AM 68 set cmd = Server.CreateObject("ADODB.Command")
69 connect = DB & ";Persist Security Info=False"
70 cmd.ActiveConnection = connect
71 cmd.CommandText = "PlayersInvolvedInGame"
72 cmd.CommandType = &H0004
73 cmd.Parameters.Append cmd.CreateParameter ("Test1", 200, H0001, 10,
"Para1")
74 cmd...more >>
Class for DDL Posted by Cedric at 2/3/2005 10:25:04 PM I want to create, alter and delete tables (not records) from ASP code. Does
anybody know of a class (preferably ASP or DLL) that hides the complexity of
the Data Definition Language?
Cedric
...more >>
ASP IMAGE MANAGER Posted by Lex Luthor at 2/3/2005 11:48:20 AM
where can i find a source like that
http://www.zhuo.org/htmlarea/standalone.html
but in asp ?
...more >>
Problem using ASP Session variable Posted by Mike at 2/3/2005 3:09:03 AM Hi all,
I have a problem using session variables.
I have two asp page A.asp and B.asp
In page A.asp I wrote this code:
Set Session(rsSession) = rsExistLog
where rsExistLog is a recordset that is the result of an SQL selection query
and rsSession is the name of the session variable in wh...more >>
ASP hanging frequently Posted by mk at 2/2/2005 11:27:04 AM Our ASP (classic) web application hangs on a daily basis. The hosting
provider claims the problem must be with the code. However, the web site
conforms to good programming guidelines (closing / destroying objects etc.).
What tools can we use to monitor / debug ASP performance, in particular...more >>
ASP reference/guide Posted by guy at 2/2/2005 11:09:05 AM Is there a comprehensive online or downloadable ASP reference and/or guide?
My searching hasn't found it yet if there is one.
Thanks
...more >>
What's wrong with this?? Posted by John at 2/2/2005 1:37:11 AM Does anyone see what would be causing the error below? This should be so
simple! I'm not seeing what the problem is.
The connection string is fine, the db, tables, and fields are identified
correctly so I don't get it!
Dim strEmail, strPassword, strSQL
strEmail = Request("Email")
strPass...more >>
SELECT * FROM... statement gives problem Posted by Bob The ASP Builder at 2/1/2005 5:08:08 PM I run an Access database 2000
I have a database, containing emailadresses stored in a text formated
column named mailadr.
I have declared as follows - part of my code
Del1 = Cstr(RecSet("mailadr"))
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "DRIVER={Microsoft...more >>
Accessing selected drop down Posted by guy at 2/1/2005 4:47:50 PM Simple ASP question. In my ASP code how do I get the value of the following
drop down:
<select size="1" name="DayP">
<option selected>Mon</option>
<option>Tue</option>
<option>Wed</option>
<option>Thu</option>
<option>Fri</option>
</select>
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |