|
|
|
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 |
easy DB question Posted by sarah NO[at]SPAM nospam.com at 4/30/2006 10:53:33 PM Hi.. I have a Access database that only has one table that contains
all the information about inventory and where it's located: itemName,
itemPrice, shelfNumber, etc.
Is there a way I can write a single query that will give me something
like this:
shelfNumber 1:
itemName - itemPrice - e...more >>
Can I convert a MS Access macro to VB and run it from an ASP page? Posted by Muggins at 4/28/2006 1:37:16 PM Been away from ASP for way too long and just getting back in for a
project.
Using IIS and Access 2003 on the server. I can set the server to
automatically download a text file report from a remote unix server,
and i've linked this file as a table in access. It can do this
periodically and t...more >>
i wanna help in deling sql server 2000 Posted by developers at 4/27/2006 3:54:47 AM
Hello every one ,
I 'm doing this sql statment,it is an insert statment. i want
to insert values into two tables at the same time . for one of thes
tables have a forigen key of the other, it can't be null. so ti wan't to
know if there is any possibility to combine the two statment ...more >>
ASP to Check if a file exists on an FTP server Posted by nvanhaaster NO[at]SPAM caitele.com at 4/26/2006 2:47:39 PM Ok I have a script that is designed to access a FTP site to GET, PUT
and DELETE files. It is initiated by a page where the user enters in a
few variables that get stored in a database for future reporting. All
that aside what I am looking for is a simple way through ASP (vbscript)
to first login...more >>
Type mismatch: 'rst' and cant get value out from database Posted by Chris Wu at 4/25/2006 12:43:26 AM <%
strODBC = "Driver={MySQL};" & _
"Server=localhost;" & _
"Database=sistemkewangan;" & _
"Uid=root;" & _
"Pwd=;"
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%
pwdNama = request.Form("pwdNama")
pwdso...more >>
ASP error Posted by jagdishl NO[at]SPAM gmail.com at 4/24/2006 9:50:13 PM Hi
I got this VB script compilation error as shown below.I checked up a
web-site which
Microsoft VBScript compilation (0x800A0400)
Expected end of statement
/Informs/membership_form.asp, line 34, column 66
The line which has the error is also shown below.Please do
adocon.Open "Drive...more >>
not adding to database Posted by Varun Jain at 4/24/2006 3:21:35 PM hi,
i was creating an asp page that is supposed to add some registration data to
a database. however, it is not adding to the database nor is it giving any
errors. this is really wierd. although, it is reading from the database.
i have attached the code for three files below
Register.asp
A...more >>
syntax error in FROM clause Posted by Varun Jain at 4/24/2006 12:48:01 PM I am assuming many people have had this problem before, but here is my code
and then the error. Thank you for any help.
---
Code
---
If Session("strUserName") = "" Then
Response.Redirect "index.asp"
End If
%>
<!--#include file="V2E2Connection.asp"-->
<%
Dim strUserName, strNam...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
I cant set validation for existing Username when submit a registration form Posted by Chris Wu at 4/24/2006 5:51:44 AM
<%
strODBC = "DSN=mysql_dsn; UID=root; PWD=;"
dim nama, syarikat, alamat1, alamat2
dim zip, negeri, negera, telefonP
dim telefonB, fax, emel, id
dim katalaluan1, sta, soalan, jawapan
nama = request.form("dNa")
syarikat = request.form("dSy")
alamat1 = request.form("dA1")
alamat2 = ...more >>
ASP with Access database Posted by jagdishl NO[at]SPAM gmail.com at 4/24/2006 1:49:38 AM Hi:
I have an asp form which would update the table created in the Access
form.This is the code which I have written but unfortunately the
update is not made to the access table after the submit button is
pressed.
f Request.Form("B1")= "Submit" Then
DB_CONNECTIONSTRING = "Provider=Mic...more >>
Html Tool Tip in IE Posted by M P at 4/24/2006 12:00:00 AM Hi!
I am using IE7 Beta 2 for html tooltips for combo box and found working thru
this code:
<option title="Capital Assets" value="09200000" selected>CA </option>
When other users using IE6 SP1 view this page, it doesn't work. Can you help
me troubleshoot the problem?
MP
...more >>
help:can't add data into DB using asp .net Posted by zheetee NO[at]SPAM gmail.com at 4/22/2006 10:43:19 AM Sub add_Click(sender As Object, e As EventArgs)
head.text=SerialNumber1.text
'msgBox SerialNumber
dim dbconn,sql,dbcomm,dbread
dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data
source=" & server.mappath("/db/equipment.mdb"))
dbconn.Open()
sql="INSERT ...more >>
security for row level but not based on Database user's login Posted by Friends at 4/21/2006 3:37:27 AM Hi
I need to set security for row level but not based on Database user's
login. It should be based on the user table login. For the particular
user I need to allow only the particular records to access insert,
update delete and select.
Let me explain clearly
For example think we are usin...more >>
aspnetdb.mdf and 10000 users Posted by eresz NO[at]SPAM op.pl at 4/20/2006 5:56:54 AM hi
how can I add 1000 users (user_name, password) from txt, csv file to
aspnetdb.mdf database???
thanks
eresz
...more >>
Error accessing MS Access Linked tables on fileshare in ASP.Net ap Posted by PÃ¥l Eilertsen at 4/20/2006 5:35:02 AM Hi,
I have a ASP.Net application that uses a MS Access database. The site works
fine when all databases resides locally but on my public server I need to use
a different database where the main databasefile resides locally but also has
tables linked that resides on a fileshare/network drive...more >>
display tables from mySQL database Posted by Prof. Goofy at 4/19/2006 10:29:50 AM hi all, i need to display all my tables from the mySQL database in a
table on an ASP/Javascript page, each as a link, so that when clicked,
it wil open the selected table for editing. unable to do it as
dreamweaver MX is not accepting 'show tables' as a valid query. how can
i go about doing this...more >>
MS Access Report to PDF Posted by M P at 4/19/2006 12:00:00 AM Hi!
I am currently working on a project that will migrate MS Access DB and Front
End to web-base solution to reduce MS Access installation. Previously, users
are using MS Access as frontend to produce customized report. I am not sure
if in a web based solution, using ASP, I can display the ...more >>
What is the capacity of an ASP-Access app? Posted by CB at 4/18/2006 2:25:01 PM I have an ASP web application with an Access database back-end (configured as
a system DSN, using ODBC and ADO, fairly typical I think.) Lately it has
been slowing to a crawl, taking 30-60 seconds to process requests that
usually take a second or two. The only other symptom I can find is the...more >>
Proper permissions Posted by mamin at 4/18/2006 6:30:21 AM Hi,
I have web application running under IIS 6.0 on Windows 2000 Server.
The application is not publicated as Default Web Site, but I've created
another instance of IIS, especially for this application. As my
application have to manage some windows service, I have to use
<identity impersonate="...more >>
test Posted by news-reader NO[at]SPAM socal.rr.com at 4/18/2006 4:08:50 AM this is a test...more >>
Simple database query using asp and ms access Posted by malcolm at 4/18/2006 12:00:00 AM Hi again folks, I want to make a simple database query using asp and ms
access.
I want to be able to query the database and return either available or not!!
ie JohnSmith is available
or JohnSmith is not availble
if the name is available it is because it does not exist in th...more >>
Compute Date and Time Posted by M P at 4/17/2006 12:00:00 AM Hi!
How can I compute time between two numbers?
Time A: 16-Apr-2006 08:00:00
Time B: 17-Apr-2006 16:00:10
Answer: Days, Time, Sec (1 day, 8 hours, 0 mins, 10 secs)
...more >>
Validate logins with ASP, MS Access and Cookies error Posted by malcolm at 4/15/2006 4:07:02 PM Hi, while trying to validate username and password on login form I am
presented with the following error message
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/vdateUsr.asp, line 53
The 2 fields within the database are text fields ...more >>
Local web server for classic asp Posted by Roland at 4/15/2006 12:00:00 AM I have a computer running Windows XP home edition and i would like to
have a local web server for testing my pages. What would u advice to me ?
thx
Roland...more >>
ADODB.Recordset (0x800A0E78) Posted by Kokseng at 4/13/2006 3:48:48 AM strODBC = "DSN=mysql_dsn; UID=root; PWD=;"
nama = request.form("dNa")
syarikat = request.form("dSy")
alamat1 = request.form("dA1")
alamat2 = request.form("dA2")
zip = request.form("dZip")
negeri = request.form("dNe")
negara = request.form("dNeg")
telefonP = request.form("dTP")
telefonB = ...more >>
VbScript/ASP and encoding help needed Posted by Kansasfiddler at 4/12/2006 11:49:14 AM Hi and thanks for reading this!
I am receiving an xml file via an ASP page using the serverXmlHttp
object. There is a french character that reads <c3><a9> which I need to
be able to replace with é. I am at a loss for how to do this using
ASP or VBScript.
I have tried the Replace() func...more >>
ASP Problem on uploading file into SQL 2005 DB Posted by Monica at 4/12/2006 12:00:00 AM I have a problem with uploading file into SQL 2005 DB using IIS 6.0
webserver, this code was working in SQL 2000 Db and IIS 5.0. Can you please
help me to see what the problem is.
Error msg :
Microsoft OLE DB Provider for ODBC Drivers error '80040e23'
[Microsoft][ODBC SQL Server Driv...more >>
Why would a SQL Server trusted login fail only after posting data? Posted by karensundq NO[at]SPAM yahoo.com at 4/11/2006 2:19:05 PM Hello
I have some ASP pages running on win 2003 under a domain account. The
pages access a SQL Server database using trusted security. The app is
fairly old and is being ported from iis5 to iis6. I have come up
against an odd problem. At first load, the page displays alright,
running whatever...more >>
Search in a TEXT File Posted by Prabhat at 4/10/2006 9:05:04 PM Hello friends,
I have one TEXT file that I use to log download information from website.
The file will have unique Login ID for the downloads. When the user will
come for next time for download the LOG entry should go under the same
section (same ID number) so for this I need to search the tex...more >>
How to LOG Download Info in <A> TAG Posted by Prabhat at 4/10/2006 5:52:34 PM Hello friends,
Currently I have one asp page which opens after the proper ID entered by
user and it generate <A> tag with application software download link. When
the user click on the link (which is pointed to the actual physical file
..EXE of Size around 10 - 20 MB) it downloads file. But ho...more >>
How to check Rediff mail from Yahoo Account Posted by suyog_linux at 4/10/2006 4:24:17 AM I want to access my Rediffmail email from my Yahoo Account . Please
tell me the procedure to do the same.
...more >>
I am stuck for few days Posted by Vedran Grubac at 4/7/2006 10:36:40 PM Hi guys I need help. I have page vich is linked with database, and it needs
to have some sort of editing text. No addning, or deleting. I know how to
display text from database, but I am stuck on editng it. So question is how
to edit page with ID let's say 10 (getting "old" text in text area f...more >>
MSN BLOCK CHECKER-MSN STATUS CHECKER-MSN PROBLEMS Posted by Pager O Rama at 4/4/2006 11:41:19 AM Hi,
R U BLOCKED ON MSN Messenger By Your Friend,then What are you waiting
for.Visit one of the link below to find out who has
blocked you in his/her friend list.
http://www.hotmailpk.com/
http://www.hotmailpk.com/msnblockchecker/
http://www.hotmailpk.com/msn-block-checker/
If you want...more >>
Dynamic DataGrid Column Posted by Justin Harter at 4/4/2006 7:30:02 AM Can someone tell me how to accomplish this. Basically I have code here that
returns a datagrid that is queried from a database. One column however
contains data as to the state of a computer (error, critical, successful,
etc) and I would like to replace this column with a picture (i.e. a red X...more >>
possible MDAC issue hanging web servers? Posted by Yoram Ayalon at 4/3/2006 1:39:57 PM Hello,
We have a web farm of
win2K machines, IIS 5, MDAC 2.6
server 2003 machines, IIS 6.0, MDAC 2.8
all connecting to Oracle DB, using ADO which use ODBC drivers. We use
MS ODBC for Oracle and Oracle ODBC. all connect using TCP connections
(thru SQLnet) to the DB server. the ODBC dr...more >>
HELP!---Stored Procedure in ASP Posted by segis bata at 4/3/2006 1:37:17 PM Hello everyone,
I'm writing you because I need help in something that's taking too long. =
I want to build a Stored Procedure to be accessed by an ASP page and I =
need that Stored Procedure to do a couple of things:
1.. Depending on parameters sent by the ASP page, do a SELECT =
statement ...more >>
Is Welfare Part of Capitalism? Posted by defendingtruthwithscience NO[at]SPAM yahoo.com at 4/3/2006 12:27:11 PM This article is dedicated to:
A man I met, with most of his body heavily burned, simply because he
was a Chinese during the 1998 May Riot in Indonesia.
Lots of capitalists that are slaughtered during the cultural evolution.
Ten thousands of peaceful smugglers that are massacred in Banda island...more >>
Must be an "updateable query" Posted by DaveFash at 4/3/2006 7:01:01 AM My ASPX procedure connects to a MS Access 2003 database to update a record.
Everything appears to be in good shape -- and existing record with the same
key
user name (indexed) . But the update does not take and the following error
persists.
## Exceptions: ##System.Data.OleDb.OleDbException:...more >>
entering a query value to an INSERT INTO statement Posted by rin.wijaya NO[at]SPAM gmail.com at 4/3/2006 3:29:10 AM Hi,
Wonder if any of you have time to assist a newbie.
I am trying to record (to an Access database) the number of clicks on
my asp page :
'insertStr= "INSERT INTO clicktrack (ItemID, ClickIP, ClickRefer)
VALUES ((SELECT ItemID FROM DocumentLibrary WHERE ItemLink = '" &link&
"'),'" & refer...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |