|
|
|
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 |
Accessing SQL 2000 (SP3) via Trusted Connection in ASP with IIS6 (Windows 2003 Server) Posted by jason.jong NO[at]SPAM gmail.com at 6/30/2006 12:47:29 AM Accessing SQL 2000 (SP3) via Trusted Connection in ASP with IIS6
(Windows 2003 Server)
I have been digging all over the internet and have had no luck in
getting this combination to work
That is using a domain service account account to access the SQL 2000
Database via ASP using Integrated S...more >>
problem invoking stored procedure Posted by Glenn Venzke at 6/29/2006 7:12:02 AM I'm trying to invoke a SQL server 7 stored procedure from asp 3.0 and I'm
having problems. The stored procedure accepts 2 input parameters and returns
4 output parameters. When I create the first parameter, I get the following
error when I try to append it to the command object:
Description...more >>
Query Problem.. Posted by AJ at 6/29/2006 4:04:02 AM Hi all,
I am trying to execute the following query:
SELECT
c.ID, c.Company_Name,
(SELECT Max(ID) FROM Sale s WHERE s.Company_ID = c.ID) AS LastSaleID,
(SELECT s.Package_ID FROM Sale s WHERE s.ID = LastSaleID) AS PackageID
FROM
Company AS c
My problem is, 'LastSaleID'...more >>
Help with global.asa & sql database Posted by Richard at 6/28/2006 1:41:03 PM Hi There
I'm attempting to clean up some code in our website so all the database =
connections are held in application variables in the global.asa file. =
This is to hopefully replace multiple forms of connecting to the =
database with multiple include files.
Here's a snip of my global.asa ...more >>
Unexpected form properties dialog box in FrontPage 2003 Posted by James S at 6/24/2006 8:02:02 AM In FrontPage 2003, I get a different dialog box from what I expect to see as
explained in the help files and from numerous illustrations in 3rd party
books. I have saved the page as an .asp file and otherwise followed the
instructions very carefully. FP server extensions are, to installed an...more >>
SQL Help Posted by James Jones at 6/23/2006 8:55:07 AM I have a list of files that a user can delete out of the database. I dont
want them to have to delete them one at a time, so i want them to be able to
check the ones they want with checkboxes. Im not sure how to use the SET
fieldname = 1
for ALL the checkboxes checked.
are ya with me? lol
...more >>
Help with query Posted by Adrienne Boswell at 6/22/2006 4:52:51 PM I am using MS SQL Server/ASP Classic and this is the query I am using
now:
SELECT distinct Category_Ipk AS category_id, category_description,
classification_name, classification_ipk
FROM view_product
WHERE (Product_Search LIKE '%dog%' OR product_search LIKE '%dog%' OR
category_description LI...more >>
Maximum length is 128 Posted by fasan21 NO[at]SPAM gmail.com at 6/22/2006 7:25:38 AM Im trying to insert binary data into a varbinary field in sql 2005 from
vb.net 2003.
Converting my data to binary I have finally gotten to work but now
inserting into tha database gives me a problem.
my code for binary conversion is as follows
Dim str As String
Dim chr As Char
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Paging Prev-Next Posted by { CrossFire } at 6/19/2006 12:54:45 AM Hi.
First I am English a little :).
My Problem:
I want to paging this page with MS Access.But i don't it.How to do paging my
code.Thanks everybody already now.
My Codes:
Note : This is an include file.
<%
if request.QueryString("CatID")<>"" then
set rs = conn.execute("Select * From urunl...more >>
Is there an ASP command to auto strip all HTML tags out of a string? Posted by Laphan at 6/18/2006 12:54:36 PM If not, any ideas on how to do this?
I just want the raw text of a string so I can display a preview of what is
in the file.
Thanks
Laphan
...more >>
@@IDENTITY in SQL server Posted by brian.lukoff NO[at]SPAM gmail.com at 6/16/2006 3:12:13 PM If I execute the following SQL statement through ASP (as one string
sent through to the Execute statement of a connection object), am I
guaranteed to get the identity column of the record that was just
inserted, or could two users get the same ID if they are both executing
the statement at the s...more >>
Merging PDF's Posted by Eric Olson at 6/16/2006 8:26:14 AM This seems simple enough in the explanation....but it is becoming
hair-pulling difficult to pull off.
All I want to do is to be able to loop through a list of PDF files (
which that part is done ) and merge them all into one large PDF
document. I have a PDF class that I found, but for the li...more >>
need help- Submitting Check Box values to Table Posted by Gaby at 6/15/2006 11:39:10 AM im trying to make an online survey. the answers are different check
boxes.
I have this written out already. maybe you guys can help.
ill give you the abbreviated sample of it:
-------
<HTML>
<HEAD>
<TITLE>Sample</title>
<%
strFilePath = server.MapPath("database.mdb")
...more >>
Sessions Posted by James Jones at 6/15/2006 11:00:01 AM few quik questions.....
i have sessions sesrt on my page to check for user ogins. if the session is
true, then they are logged in. would it be better to use cookies? i havnt
learned how to use those yet, but i can learn. (if thats best way, then
anyone provide me a link to a good tutorial...more >>
Connecting to MS Access database from ASP in Windows Server 2003 64-bit Posted by Michael W White at 6/15/2006 8:25:56 AM I'm setting up a Windows Server 2003 64-bit machine for a user. It will be
serving ASP forms with MS Access as its back-end database.
I created a simple ASP webpage and it is displayed without any problem.
I created a MS Access database on the server and a ASP webpage to connect
to the...more >>
large varchar columns in SQL server Posted by brian.lukoff NO[at]SPAM gmail.com at 6/15/2006 4:57:09 AM I recently came across an article
(http://www.aspfaq.com/show.asp?id=2188) which said:
--
Depending on the version of your MDAC driver, and the database you are
connecting to, these columns can either (a) not show up at all, (b)
only show up the first time they're called, or (c) cause 'Unspecif...more >>
Two simple ASP questions Posted by brian.lukoff NO[at]SPAM gmail.com at 6/13/2006 5:54:56 PM Two simple ASP questions:
1. If I am iterating through a recordset, and then for each record
iterating through the fields one or more times (using a For Each...Next
loop), am I assured that the order in which I iterate through the
fields will remain unchanged throughout the iteration of the re...more >>
find empty sring in sql server Posted by sdmusicmaker at 6/13/2006 11:59:02 AM ok i kinda feel dumb here but i have a CHAR column in SQL server who's values
could be alpha, Null (by default),or blank.
I cant seem to test for the blank. i tried ' ' and " " but itd oes not
work. In Query analizer this works:
select wo_user_alpha_1 from EMORDLIN_SQL where wo_user_alpha_1...more >>
How to prefill the Form? Posted by sdmusicmaker at 6/13/2006 7:55:02 AM Hi,
interesting puzzle that has me a bit stumped. I have an ASP detail page that
shows an image of a product , checkboxes and a submit button. The quanity of
checkboxes on the page is determined by the value of DB lookup to a table
that has a column called MaxHoles. So for instance if the pro...more >>
Checkbox Validation and dynamic name set Posted by clinttoris NO[at]SPAM hotmail.com at 6/13/2006 6:46:34 AM Hello experts,
I need to write validation for dynamic checkboxes that have been
constructed using the following syntax.
response.write "<input type=checkbox Name=""Question" &
objRS("Question_ID") & """ Value=""" & objTxt("Sub_Text") & """>" &
objTxt("Text") & "<br>" & chr(13)
Can anyone...more >>
Help with Microsoft JET Database Engine error '80040e4d' Posted by jmev7 at 6/12/2006 4:29:43 PM I know why this is happening to me. It's due to a database password on an MS
Access file. I can put code in each page that calls the database and
redirect the user to the log in page, but I was wondering if I could trap
this error and cause it to be dealt with as I would a 404 error. Is there ...more >>
Stored procedure Output Parameter headache Posted by Monkey Pi at 6/12/2006 1:46:06 PM Hey all, and apologies if this is in the wrong place
I have the following code chunk for a page which accesses an SQL Server
2000 stored procedure that takes an SSN and a Last Name and checks our
database for a match.
The stored procedure works fine in Query analyzer, returning the
parameter...more >>
Need advice on prompting user for password on Access database Posted by jmev7 at 6/10/2006 5:36:45 PM I am writing an ASP page (classic, not .net) to an Access database, and am
considering sending the user to a start page where they are to provide the
DB password. Would prefer not to use user level security - yet. At this
start page, they would enter in the DB password, I would write this to a...more >>
Need Help SQL query Posted by rahulbindlish NO[at]SPAM gmail.com at 6/10/2006 8:17:16 AM Hi,
I have to search in database in which structure of table is like this:-
----------------------------------------------------------------------------------------------
Col 1(Foreign Key) Col 2 Col3 Col4(Primary
Key)
--------------------------------------------...more >>
problem with ASP page Posted by Kal at 6/9/2006 3:48:30 PM Hi,
I wrote a basic asp page to do a simple 'select' from an ACCESS
database. When I run the page, it just hangs and hangs. What am I doing
wrong?
I am using ACCESS 2003 and I don't know what version of ASP I am
running but its NOT asp.net. It is whatever is supported with IIS 6.0.
below i...more >>
upload to database error from ASP Posted by Rahul Chatterjee at 6/8/2006 4:19:45 PM Hello All
I have a web page which reads in a csv/fixed width file and builds an XML
DOM which gets parsed and uploaded into a database.
Below is the stored proc which does the upload into the database. The file
is read in by the asp page and the string is built. This program works fine
for sm...more >>
Display Information from 3 Tables Posted by Wayne & Carr at 6/8/2006 4:09:29 PM Hello All;
Now, I am trying to get the [Search Results] Page to Display And right now,
it is simply giving me a Blank Page, but no Errors.
See, I am retreiving information from 3-Tables.
Cats - Contains information about the Categories
Sierra - Datafeed #1 Content
BrushStrokes - Datafeed #...more >>
What are your thoughts on this??? Posted by Shawn Ferguson at 6/8/2006 8:24:51 AM I have created a application generator creates the add, delete, change, =
view database code and ASP code that will work for classic ASP and SQL =
Server 2000. It has been an instrumental piece that has saved me NUMEROUS =
hours, all I have to do is give this application the fields, and viola.....more >>
stumped on sql... Posted by sdmusicmaker at 6/7/2006 8:48:01 AM using SQLServer.
i have a db table called Orders. It has a collumn called user_alpha. The
values in that collumn are A for one row, ABC for another, and C for the
other row. I need to know how to return the number 5 because that is how many
letters there are total for all the rows. It is base...more >>
How to store date in SQL server getting input from html form. Posted by SSG at 6/7/2006 5:05:08 AM How to store a date in ms sql server , using asp, how to write the
insert statement to do this.?
...more >>
ASP - FROM statement slows down connection to database Posted by Wayne & Carr at 6/4/2006 11:21:17 PM Hello All;
The following code is used in conjunction to a Navigation system that I
have
On several smaller site(s) (Of which are steadily growing). And the code
works great.
But, on the newest site that I am developing, the code really just bogs down
the
Connection to the Access Databas...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |