|
|
|
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 Free ASP resource! Posted by Me at 12/31/2003 10:57:45 PM Hi!
could someone plz tell me where can i found some asp free resources.
such as asp guestbook and forums ...
Thanks in advance
...more >>
SQL Database in ASP Posted by Robert Cohen at 12/31/2003 3:33:52 PM Hello All,
I don't know if this is the right group or not to discuss this issue =
with, but I am hoping so. I have an SQL database and am trying to use =
frontpage as my interface. I am able to query the database fine and =
present the data on a webpage; however, I want a way to modify- ad...more >>
SQL Statement looping Posted by PorkyJr at 12/31/2003 1:39:46 PM
Trying to pull a report from an access 2k database that grabs the top 5
records for each day in a range (inputed by user). Yes, I know that the
* character is not a good idea, but I put it here for brevity.
Here is my SQL Statement:
LTQry = "SELECT TOP 5 * FROM History " & _
"W...more >>
Help with OLEDB connection string Posted by Matt at 12/30/2003 4:51:50 PM Hi,
I'm following the below example in order to create a connection to my Access
database. My question is, is it possible to include the username and
password as part of the connection string? I've tried appending
"UID=username;PWD=passsord" to the cst connection string, but I get a "Not a
...more >>
help me with crystal reports. Posted by haode at 12/30/2003 4:37:54 PM I'm in trouble with reporting data on web with crystal reports.
for me it's not easy to find some sample codes(ASP).
does anyone have some example asp codes?
I use Windows 2k server and SQL server 2k.
TIA.
...more >>
no records Posted by Jen at 12/30/2003 2:52:20 PM Hi,
I am writing a jsp page to get data from db.
<%@ Language=VBScript %>
<!-- #include file="ConnString.asp" -->
<html>
<head>
</head>
<body>
<%
dim rsLook
dim sSql
dim arResults
dim i
Set objCon = server.createobject("adodb.connection")
objCon.open strConnString
sSql = ...more >>
Simple but complex report Posted by AstrA at 12/30/2003 12:49:02 PM Hi All
Wondered if you could help.
Basically I have 2 tables that contain all the data I want for my report,
but I need to put it in a particular way and I need to display it in an ASP
page so my queries got to be manual rather than an MS Excel/Query 'munge'.
To be honest, the report itse...more >>
OLEDB connection string help Posted by Gabriel at 12/30/2003 12:20:05 PM I'm trying to connect to a SQL Server using dsn-less
connection string such as "PROVIDER=SQLOLEDB;DATA
SOURCE=SQLSERVER;UID=DOMAIN\username;PWD=password;DATABASE
=myDB" I know it works with Standard SQL Server
authentication but is it possible to use Windows
authentication like in the exam...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Storing Images in SQL Server - ASP storage and retrieve Posted by Michael Walton at 12/30/2003 12:04:54 PM I need some help, because I am utterly confused with how to do this. I have
2 things that I need to figure out, and could use some sample code or just
some general direction:
1) I need to build an admin page that allows me to browse to the file that I
want stored in SQL Server 2000 in an imag...more >>
search query doesn't work Posted by m.krechting NO[at]SPAM chello.nl at 12/30/2003 9:07:28 AM Hi ALL,
I have made a record search form with several search options.
However some of them work and others don't. The first four work but
the last six don't.
'WeaponSearch Class_Initialize Event @2-0BECB200
Private Sub Class_Initialize()
Visible = True
Set Errors = N...more >>
Complex situation Posted by Mike at 12/30/2003 7:34:29 AM OK, here's the scenerio.
One department here uses the same Access database (on a
network) for various reasons, all different, but with the
same data. Now, I've created a separate SQL Server db to
house new applicants via a website.
The SQL Server sits alone and cannot see any network...more >>
ASP - Server Not Found Posted by Arthur E Oliver at 12/29/2003 8:42:42 PM I am at my wits end.
Could someone please help. I developed a web on a Win2000 Server\IIS machine
and it worked perfectly on that machine. I have since bought a new computer
and installed Win Server 2003. I then installed all my software from the
other Win2000 Server computer. When I run my web ...more >>
how to display data in 3 columns by 4 rows format Posted by addi_s NO[at]SPAM hotmail.com at 12/29/2003 8:21:12 PM All,
I will be eternally greatful if someone can provide snippet of code,
URL or reference material that shows how to display data in a "n
colums * n rows" format.
I am new to ASP and have looked everywhere that I could, but I have
not found an example where data can be formatted to be dis...more >>
get id number from sql table Posted by shows NO[at]SPAM hillstax.org at 12/29/2003 12:55:59 PM I have a asp page that updates a sql table. after the table receives
the update a id number is auto generated. How do I pass that number
to the second page. I was trying to use @@identity but I'm not sure
how to use it or ever were. Do I call the @@identity on the second
page? Please help...more >>
Transaction Error Posted by Niel at 12/29/2003 9:44:18 AM Hi,
I am working on ASP 3.0 with MS SQL 2000. We have an
online registration form where in once the information is
submitted (along with credit card info.) the information
is taken on another asp page where i have set the page
level transaction (transaction = required) on.
Once the infor...more >>
Connection from ASP Page to Oracle Fails Posted by Brian at 12/29/2003 9:06:47 AM I am trying to connect to our corporate Oracle database to
query some data in an ASP page. My experience with ASP has
always been with SQL Server and Access databases, but I
figured I could get a connection string to work. I tried
using the following connection string:
"Driver={Microsoft OD...more >>
Function Problem Posted by MyaTiX at 12/29/2003 5:00:07 AM Hi,
I have the following function below used to make a couple
of calculations however as soon as I have two records the
function calculation is wrong.
EG:
Record 1:
tmprs(0) = 1
tmprs(1) = 100
tmprs(2) = 20
tmprs(3) = 25
Record 2:
tmprs(0) = 1
tmprs(1) = 1000
tmprs(2) = 10
tmpr...more >>
Thanks for the help! Posted by MyaTiX at 12/29/2003 1:50:35 AM Hi Ray,
Thanks for the help! I managed to sort it!
...more >>
login Prob Posted by josephrthomas at 12/28/2003 10:17:35 PM hi..i am trying to make a login page and i am using access
table..
when the user enters his userid and password i want to
check the password from the table..
if any user with the userID that is entered exists i want
to find the correspoding password for him else i want to
throw an error ...more >>
How to connect from IIS to IBM DB2 mainframe Posted by anonymous NO[at]SPAM discussions.microsoft.com at 12/28/2003 10:00:41 PM Could someone tell me step by step what to do to make a
connection to DB2.
I have to write an application which will display DB2 data
on the web.
My experience level is 5 years with classic ASP & one
month with ASP.net.
I understand that I have to use ADO.net. But after that I
am lost...more >>
Get last part of a string Posted by m.krechting NO[at]SPAM chello.nl at 12/28/2003 3:46:31 PM Hi All,
I'm trying to get the last part of a string.
In VB there's a function called lastinstr() who does the work.
But it doesn't seem to work in ASP.
The string I have is for example:
D:\Marco\ASIC2000\Images\Weapon\leo1schrägmit.jpg
Now I want to get rit of everything before the last "\...more >>
Show memofield in seperate form Posted by m.krechting NO[at]SPAM chello.nl at 12/26/2003 3:59:43 AM Hi all,
I have a asp-page that shows all data from one record in my database.
Every record also has a memo-field but since there's so much text in
it I wanted to have a button on my form that will open a seperate form
containing the memo-field. So a user can always decide if he wants to
view ...more >>
IIS and Access on home computer Posted by Jon at 12/25/2003 6:10:37 PM Like most here, I guess, I trial my asp / database web sites on my home
based machine before they go live.
Are there any settings (Win XP Pro / Access XP) I can set to allow me to
have the database open in MS Access AND be able to access the data via my
web pages?
Thanks
Jon
...more >>
How to show an image on my page Posted by m.krechting NO[at]SPAM chello.nl at 12/25/2003 4:20:57 PM Hi folks,
I use an access database with a textfield (ImagePathAndFile).
In this textfield I store the full path to an image, for example:
(C:\MyDB\Images\MyImage.jpg).
Now I want to show this image in an asp page containing only one
record. Do I need an Image or an ImageLink?
I thought I...more >>
3 days without sleep, posting here as a last resort Posted by tsiuweng NO[at]SPAM msn.com at 12/24/2003 9:46:07 PM Hi everyone,
I'm developing a web application(VideoRental) using ASP with Access
as the database. My machine runs Windows XP. In my codes, I'm using a
DSN connection to the database.
Initially, whenever I click on the page that's supposed to trigger
another page containing the ASP c...more >>
Provider cannot be found error Posted by Peak at 12/24/2003 6:04:19 PM Hello all
Windows XP SP1
I'm trying to connect to a local MySQL database through ASP (VBScript, also
tried JScript, same result). IIS is on the same machine.
connect = Server.CreateObject("ADODB.Connection");
connect.Open("Provider=MySQL; Data Source=localhost; Initial Catalog=test;
User...more >>
How can I deny users changing records Posted by m.krechting NO[at]SPAM chello.nl at 12/24/2003 1:42:39 PM Hi All,
I have an Access db which has a LoginCheck table.
I use this table to login with name and password.
But there is also in the table a field right which can be
"read" or "write".
I want to be able to use this field so users which can may
only "read" do not enter a page where a record c...more >>
Paging Posted by Ranger at 12/24/2003 1:16:29 PM Hi guys,
I have a search page with some criterias. SQL query created in separate
include file (SearchCriteria.asp) based upon choosed criteria. I choose
criteria and go to result page. For instance, "SELECT * FROM Table1 WHERE
x=5". Paging works fine only for first page. When I click NEXT, LAS...more >>
Beware scorpion53061(thief) Posted by IAmIronMan at 12/24/2003 9:56:37 AM This individual is stealing other peoples code and
claiming it as his own. The proof is when I asked him to
explain his code he would not.
For proof view these threads in dotnet.languages.vb
Giving Back(Thank You)
scorpion53061
Straighten This Out....
This is the forged code he won'...more >>
Preserving the original URL in address bar after a redirect. Posted by leefarrant NO[at]SPAM hotmail.com at 12/24/2003 3:55:13 AM I was browsing the web the other day and a website I had a look at
redirected you to a different webpage but still preserved the original
URL that was typed in the address bar on the browser (it didn't move
or change at all) How is that possible? I would like to do something
similar.
The reas...more >>
How to show record in new form by clicking on name Posted by m.krechting NO[at]SPAM chello.nl at 12/24/2003 1:21:36 AM Hi All,
I have a asp-build grid with some records.
The name of a record is a {Link}. I want to be able to click
on the link and open a new asp-form that has an editable grid.
That form must only show the record which was clicked.
This is the query I use in the new form:
SQL = "SELECT * ...more >>
Backup Posted by Clive Moss at 12/24/2003 1:13:25 AM Hi all
I am looking to automatically back up a Access 2002 database, hosted on a
remote server, with some asp code on a daily basis.
Can anyone point me in the right direction
TIA
Clive
...more >>
How to ensure 2 places to right of decimal Posted by Shawn at 12/23/2003 4:56:11 PM How can I make certain that decimal values print out 2
places to the right all the time when displaying them on
a website coming from an Access database. Its defined in
the database as a Number, Single, Auto, should I make it
Number, single, 2? I need it to print out like shown
below.
...more >>
Use MSDE in application Posted by Grey at 12/23/2003 4:25:08 PM Dear all
I want to know that can i use MSDE as database server for deploying =
application. Is it necessary to buy any licence if I use MSDE as =
database server in Windows 2000 server. Moreover, is MSDE designed for =
multiple users access like SQL Server?
Million Thanks
Eric...more >>
Abnormal End Of File Posted by George Fernett at 12/23/2003 1:59:46 PM Hi all,
I have the following in an ASP script:
(note: "ccode" is a checkbox collection from a previous ASP script)
<%
dim choices, oCmd, oRS
set oConn = GetConnection()
choices = Request.Form("ccode")
choices = Split(choice...more >>
ASP Code to generate the schema of an SQL Table (field name, Data types , Size) Posted by Robert at 12/23/2003 1:21:36 PM Anyone has this SQL STATEMENT to traverse the User defined tables?
I just need the Select Statement to get this info the rest I can handle.
I am not interested is revealing the system table information just my
created tables schema.
Psuedo code like as follows:
dim cn ...more >>
About www.aspfaq.com Posted by Ray at <%=sLocation% at 12/23/2003 12:01:14 PM Message from Aaron about www.aspfaq.com issues:
I'm in the midst of switching database hosts, but I'm on vacation (out of
the country) until January 4th. So, it's been a bit tougher than I expected
to oversee it remotely, and the people who are helping me are only available
outside of busines...more >>
ASP.NET access denied to SQL Server 2000 Posted by Jan Bannister at 12/23/2003 9:36:06 AM I've been working on a WebService project with a local
datasource. I moved the datasource to be another server.
So now IIS and SQL Server are on different machines. And
now i perpetually get:
SQL Server does not exist or access denied
Things I've tried:
1. Changed the <processModel> usern...more >>
Getting HTML content from one Server and Saving it on another Server Posted by rene.aube NO[at]SPAM gnb.ca at 12/23/2003 6:48:28 AM Hi everyone,
I'm incharge of updating the stats on a chl hockey teams Web Site. I
would like to know if there is a way to be able to save
the content of the CHL Statistics WebPage on our Server and using it
to update our Microsoft Access 2000 database.
If it possible, then I would take the ...more >>
Really need HELP from a GURU Posted by MyaTiX at 12/23/2003 5:43:05 AM Hi I'm trying to get a page working that calculates the
total cost of a product by adding a percentage tax amount
and subtracting a discount or not as the case maybe.
I have a form which the user enters the
- Discription
- number of units,
- discount in %,
- unit cost
The user can the...more >>
Release the lock propertities of recordset Posted by DS at 12/22/2003 5:26:34 PM Within an ASP page, how can I release the lock of a recordset and then set
values to the fields?
After listed all data with a table, I tried to update one of fields, but it
pops up error:
<%
'Update records.....
If oRS.supports(adUpdateBatch) then
oRS.MoveFirst
While Not oRS.EOF
oRS...more >>
How do I retrieve error messages when using cmdSP.execute in ASP on a stored pro Posted by Geek at 12/22/2003 3:13:39 PM If an error occurs during the "cmdSP.execute" statement
below, how can I
trap it? Right now, the below ASP code doesn't inform
the user if there's
an error executing the stored procedure.
Thanks.
set cmdSP = Server.CreateObject("ADODB.Command")
cmdSP.CommandType = adCmdStoredProc
...more >>
Updating a text field in SQL Server 2000 Posted by Michael Walton at 12/22/2003 11:01:33 AM I am trying to write some code that inserts or updates a text field in my
SQL Server 2000 database. The SQL statement is created using a submit from
a form, and the text is coming from a <textarea>, and therefore being placed
into the SQL statement via a Request("field"). However, due to limita...more >>
How to show images from access database Posted by m.krechting NO[at]SPAM chello.nl at 12/21/2003 3:02:27 PM Hi all,
I'm new in ASP so,
I have an access db with a table called IMAGES.
It has two fields (IID and ImagePathAndFile).
IID has the ID of the main table WEAPON and ImagePathAndFile holds
the path to an images on the HD.
I want a new window to popup with the image when i click on the name
...more >>
Advice on reporting via ASP Posted by Jeff Boyer at 12/20/2003 3:04:59 AM Hello everyone,
I have recently developed a web application across my clients intranet. We
used ASP with Interdev 6.0 and SQL server as the backend.
They have now come to me asking me to develop some reports that can be
accessed via a drill down within the app. They don't have Crystal Report...more >>
SQL Server on Windows XP Pro and ASP Posted by Nathan Sokalski at 12/19/2003 4:21:12 PM I want to set up SQL Server on Windows XP Pro so that I can use the database
capabilities of ASP and IIS. I am probably using some incorrect settings,
but I am not sure what they are. Here is what I am currently doing:
When I run sqlservr.exe I see the following:
2003-12-19 15:51:28.20 ser...more >>
Query empty records Posted by Luis at 12/18/2003 12:16:53 PM I have a simple query to retrieve total order amount by customers, ie,
selet customers.customer_id, customers.customer_name,
sum(orders.order_amount) as total_orders from customers inner join, etc,
etc...
which work fine but only retrieves those customers for which there are
orders....
a...more >>
Specified driver could not be loaded due to system error 126 Posted by Brian at 12/18/2003 8:06:33 AM I am trying to connect to an Oracle db with my ASP page. I
have a system DSN which works just fine (I can use it to
connect to the database through Access). Here is the code
I am using:
dim objConn
set objConn = Server.CreateObject ("ADODB.Connection")
objConn.Open "DSN=ORDERS; Uid=...more >>
Incrementing a Long Integer in an Access table Posted by madfiddler at 12/18/2003 7:46:05 AM I am executing the following SQL on an Access table from
ASP
UPDATE MYTABLE SET MYCOUNT=(MYCOUNT + 1)
Unfortunately this seems to add 2! If I add 2 in the code,
the actual result is +4! If I do -1, then the result is -2.
If I change MYCOUNT to an Integer from a Long Integer it
works...more >>
Connecting to linked SQL tables through access Posted by Bonnie at 12/18/2003 7:03:48 AM Hello,
I have searched the web and can't find a solution, but
this must (maybe) be common. I am creating an asp page
that connects to an access database which contains linked
SQL tables.
I can query and manipulate data in tables that aren't
linked, but when I try to run a query (qry...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |