| 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 |
Speeding up retrieval for CMS system Posted by I create a content management system using SQL Server and ASP that uses 2
tables, content and categories. Structure listed below:
content
contentID identity int
categoryID foreign key (int)
Title varchar(100)
Body text
status char(1)
category
categoryID identity int
categoryname
des...more >>
Access db search result behaviour Posted by Richard Rosser at 8/25/2006 11:31:13 AM Hi all.
The following search was built with frontpage 2002 to query an
Access table. At the moment it insists on a value in both
fields or returns an error. How do I write this so an answer
in either one or none or all fields produces an answer.
i.e. if no fields of the search form are com...more >>
function in sql Posted by לי×ור.×’ at 8/22/2006 1:43:02 AM hi
i create sql function like this:
function select_snif (snif )
if snif <> "" then SQLstr = "SELECT * FROM SWITCH where snif like '" &
snif & "'order by snif,id "
end function
i want to call this function in onchange tag how i can do it?
if i must to change this function to a...more >>
Syntax for Request.From with Variable?? Posted by Mal Reeve at 8/19/2006 1:22:43 PM Hello,
I'm trying to loop through a response form, read the value of a given
response....then later write it to a database.
I am having problems with the following code...and am thinking that I have a
problem with the syntax of reading the form response.
Code is as follows.......(Cause ...more >>
Entire recordset not being exported to excel Posted by sks at 8/17/2006 3:55:05 PM Hi all,
I'm trying to export a recordset from a webpage to excel, however, only
part of the recordset does not populate in the excel file. The entire
recordset will populate if I have it write to a web page. I'm using
the following script to initiate the export:
<%Response.ContentType = "...more >>
Microsoft JET Database Engine error '80004005' on a New Server Posted by bluerose_0 NO[at]SPAM hotmail.com at 8/17/2006 3:08:11 PM Please help! I've been scouring the newsgroups and been through
Microsoft's troubleshooting page, but can't find anything to fix this,
so far. It sounds like a lot of people have been having a similar
problem, though.
We just copied an ASP website and MS Access 2000 database to a new
server...more >>
Adding records within a loop Posted by Mal Reeve at 8/17/2006 2:55:48 PM Hello,
I am experienced in Access, but new to ASP....
I have an online survey that I want to add results to an access table...by
using a saved query with paramaters...
Not sure where my code is failing....or for that matter what the best way to
go about testing it is....
The SQL of t...more >>
id of new record Posted by Jon Paal at 8/16/2006 8:28:57 AM I can't seem to get id of new record. What am I missing ?
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;"&_
"Data Source=" & Server.MapPath("/mydb.mdb")
set conn=server.createobject("adodb.connection")
conn.Open strCon
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Curs...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Another date format question Posted by Rey at 8/15/2006 7:10:39 PM Howdy all.
2 questions related to dates.
Thanks in advance,
Rey
Trying to understand the reason the following displays as it
does...when attempting to save a local variable.
declare @effDate datetime
set @effDate = convert(varchar, getdate(), 101)
select @effdate
-- displays 2006-08-1...more >>
tring to set date using asp and the year value get corrupted Posted by alon at 8/15/2006 12:49:16 AM when I tring to set date (oracle) through my asp page
the year value get corrupted the date format I am using is 'dd/mm/yyyy'
2006 become 0006
2005 become 0005
I hope someone will answer me
Thanks Alon
...more >>
how to backup only a few tables? Posted by mike at 8/14/2006 3:14:18 PM Heya guys,
I want to pack up a few of the tables in my database to send to a
developer to develop aspx code. I was thinking it would be great to
create a .bak file with just those tables he needs to do the
development. Is there a way to do this? How about an MDF file?
Regards,
Mike
...more >>
need urgent help please Posted by kester21 at 8/12/2006 7:39:53 AM hi, i am trying to update a recordset in access using a variable
for example
varStore = "4th Avenue Store" or it could be "10st Street Store"
my recordset is rstStore
i want to post to my recordset like this
rstStore!" & varStore & " = 5000
but it doesn't work, ANY IDEAS PLEASE
...more >>
Call Access form by ASP Posted by Eric at 8/11/2006 3:38:42 PM Hi: Is it possible i call access form in browser.
Thanks,
...more >>
Access db problem trying to retieve date Posted by jtrainaldi NO[at]SPAM gmail.com at 8/8/2006 8:21:32 AM Basically I am trying to access all entries from a database that equal
the current system date.
I am using an ASP page accessing an ACCESS DB. I am not getting any
errors but the database is not retrieving anything. However, when I do
a SELECT * FROM Events i get everything.
My code is:
...more >>
Error 8007007e Posted by Rodrigo Sosa at 8/7/2006 10:33:00 PM Dear Engineers.....Help!!
Every time I try to execute with IE an .asp page that has the following
code:
<%
ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=C:\Inetpub\wwwroot\database\xxx.mdb"
Set Session("DB") = Server.CreateObject("ADODB.Connection")
Session("DB").mode = 3...more >>
Pattern Matching Posted by Eric at 8/7/2006 3:00:24 PM I use RegEx to search pattern. Script works fine in the situation when
there is a colon after each word and it fetch the rest of the word from
that line. Now the pattern is in square bracket and i need help how to
change that line (sPattern =
"From\:\s*([\s\S]+?)[\r\n]+") so that it search pa...more >>
Problem connecting to MySQL in IIS through ASP/VB Posted by Alan at 8/7/2006 4:03:46 AM Hi,
I've been having problems trying to connect to MySQL through IIS via
ODBC in ASP.NET (using VB). When I run the code in Visual Studio it
works fine -- i.e. I'm able to enter data into the MySQL table. But
running it under IIS it just won't work - no error messages, but with a
few message ...more >>
ASP website validating against Active Directory? Posted by Noozer at 8/4/2006 12:00:00 AM I'm currently developing an ASP based intranet tool to maintain a database.
Currently, I have a table of users within the database which I use to
validate users when they log into this tool.
What I'd like to be able to do is pull user information directly from the
Domains active directory i...more >>
General Network Error from ASP Application. Suggestions Required. Posted by mohanv NO[at]SPAM gmail.com at 8/3/2006 12:18:35 AM Hello,
We are facing the 'General network error. Check your network
documentation.' error at random from our ASP application on Windows
2003 connected to the MSSQL 2000 database server through a crossover
cable. We receive both recv() and send() errors. The only peculiar
similarity between th...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |