|
|
|
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 |
WRITE SQL DATA TO LOCAL MACHINE Posted by Simon Gare at 3/30/2007 12:00:00 AM Hi all,
have an SQL DB which clients access via asp pages through the internet, in
the case of a power outage I need to write that data automatically in the
background to a txt file on their local machine, I would imagine it would
involve a script of some kind.
Can anyone help?
Regards
...more >>
'weekday' is not a recognized built-in function name Posted by Bart at 3/29/2007 12:00:00 AM Hi,
I ran this code first with OLEDB provider for ACCESS without problem. Now i
switched to Sql Server 2005 express but i get the error: "
Microsoft OLE DB Provider for SQL Server (0x80040E14)
'weekday' is not a recognized built-in function name.
Thanks for help
Bart
global.asa:
---...more >>
Passing info to SP Posted by Adrienne Boswell at 3/28/2007 5:01:57 PM Using MS SQL 7 - I would like to pass the name of the view to use, and
the cities (in a list)
Here's my SP
CREATE PROCEDURE sp_getcategories_CA
@classification INT,
@cities INT
AS
SELECT vr.category_description AS description, vr.category_ipk AS cid,
vr.classification_ipk AS clid,
count...more >>
Undefined in my Database Posted by azza at 3/27/2007 4:19:56 PM the data that i key-in at my ASP become "undefined" in my database. what the
problem n how to solve it?...more >>
Help With Field Searching Using Wildcards Posted by Andy at 3/27/2007 11:25:48 AM Hi Gang
I have a small database application where the user can search
different fields. They select what they want to search on and enter a
value to search on. For example
They select part number and enter "123" into the search field.
This searches the database for that field with LIKE ...more >>
asp.net Posted by ks_anishaa NO[at]SPAM yahoo.co.in at 3/25/2007 11:50:05 PM Dim strImgId As String = Request.QueryString("id")
Dim cmd As New SqlCommand("select img_data, img_type from imgdisp where id=" & strImgId)
when i am using this i got an error like incorrect syntax near ="
what i have to do?...more >>
Question about pull down menus on asp forms. Posted by Brave at 3/23/2007 10:48:23 AM I have two questions about pulldown menus on forms.
1: Can I have the options of one pulldown menu be dictated by the
choice from another pulldown menu (example beow)?
2: Can I have a form be submitted when a choice is made in a pulldown
menu (example below)?
Example of question 1:
I h...more >>
Error with Connection Objectq Posted by Bryan at 3/22/2007 12:33:04 PM Hey guys, I need a bit of quick help. I have a website that I have been working that worked fine while I was working on it on my computer, but I just tried to publish it now to the server and keep getting an error. Here is the error that I am getting:
Microsoft OLE DB Provider for ODBC Drivers ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Simple SQL ORDER BY doesn't work! Posted by Steve Bottoms at 3/20/2007 6:40:56 PM Simple query, ordered by dDateField desc, cCharField asc, nNumericField asc.
Irrespective of whether I have the "ASC" keywords in there, it's behaving as
though the query is specifying DESC on all three order fields. This seems
pretty basic, but it doesn't work in either IIS6 or IIS7. Is the...more >>
asp and xml Posted by Yobbo at 3/11/2007 8:28:57 PM Hi All
Can I use an XML file like I could a database, ie select, insert, update and
delete from it?
If so, how would one do this via standard ASP calls?
If you can't use SQL-style commands how do you use it for storing info?
The reason I ask is that I need a few params storing on a cen...more >>
Code is executing twice Posted by william NO[at]SPAM seritas.com at 3/7/2007 12:20:38 PM I have reduced my code down as far as it will go and can duplicate
this issue at will. I have an ASP page containing a SQL insert. When
the page is first loaded, the insert happens twice. There is a
"response.write now" statement for debugging purposes, and it only
happens once.
The code is...more >>
Invalid class string Posted by r0ckster at 3/6/2007 9:25:48 PM hi!
i'm getting this error when i run my asp app in windows xp.
Server object, ASP 0177 (0x800401F3)
Invalid class string
/cem/reports/AlwaysRequiredSteps.asp, line 9
This app works well in windows 2k but when i upgrade my pc to xp it produced this error.
This error points to this cod...more >>
Help- Add, Update and Delete using ASP for MS Access Posted by crab.dae NO[at]SPAM gmail.com at 3/5/2007 1:14:22 PM Need a little help please. I've got the below to add records to a
table, but I need to learn how to do updates and deletes.
Could someone give me examples of how to update and delete a record
based on the below?
For update, I'd like an example on how to update the Location based on
frm_cna...more >>
Warning user before db update Posted by AndyK at 3/3/2007 10:42:00 AM hi all
I'm using ASP for a little database application. I can't figure out a
simple design for warning the user before doing an update or append. I need
to check for any other existing records with the same (non-key) data as in
the new or updated record.
Your advice would be most welco...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |