RC — Sat, 01 Jul 2000 17:48:41 +0000

Try this:

SELECT *
FROM table
WHERE ID = $id;

take out the single quotes and try it.

Gil — Wed, 28 Jun 2000 04:34:00 +0000

I had to bring up this old thread, as there are some updates. I installed SQL Server, but I have a question for Peter. I setup indices as a way of doing "auto incrementing" for a primary key. But for some reason when I try to compare data and select a record using the indexed key, it returns an error saying that I am trying to make the column a varchar when it actuallity it is a bit column. Here is what I am trying to do:

SELECT * FROM table WHERE ID='$id';

Now $id would be a number, let's say 143. And the record I am trying to select also has 143 as the value for the indexed ID field. Any reason why it's acting this way?

------------------
Aristotle concluded that those who admit their stupidity are truly wise.
Gil Hildebrand, Jr.
Senior Web Developer, 4atcost.com

Gil — Thu, 20 Apr 2000 04:40:00 +0000

ASP isn't a nightmare, but for me using Drumbeat was. I've never used dome damn program for making my applications, and I wound up creating 20 or so "Contracts" just to be able to use the thing. Basically I wrote 90% of the program myself. I didn't find that Drumbeat helped as much as I though.

I think ASP is definitely excellent for database interaction, however I prefer a PHP/MySQL/Apache environment. And no I'm not knocking it before I try it. I've used both extensively.

The reason I chose ASP for this project was 1) it needed to run on Win NT 2) It needed to use ODBC interaction (for outside reasons). For that I figured ASP would beat PHP. In fact it does, but it turned out to be more time consuming. Yesterday I was about to download ASP2PHP. Luckily I finally got everything straightened out.

------------------
Gil Hildebrand, Jr.
Senior Web Developer, 4atcost.com

Peter J. Boettcher — Sun, 16 Apr 2000 14:06:00 +0000

Gil,

I'm curious, why do you find ASP a nightmare? I find it to be a fairly powerful and simple server side technology, and I think for interfacing with databases it's definately on the top of my list.

I guess it's just whatever you're comfortable with.

Regards,
Peter J. Boettcher

Gil — Sat, 15 Apr 2000 04:31:00 +0000

Thanks a lot. That's just the answers I was looking for

I would think that Microsoft keeps track of how many simultaneous users access SQL Server, given that the unlimited license release costs around $30,000. But maybe you're right. I doubt 5 users will access the database at one time, but I am always looking at possibilities. I'm trying to not increase the cost too much, since this project is costing in the 10k already. I suppose if there are database problems, and it does keep track of connected users, I can buy an unlimited internet user license. BUt I doubt it will be needed.

When I started this project, I was almost going to use a DSN-less connection, but I decided not to for this very reason. Once again, thinking ahead.

I appreciate the help, and I'l lbe sure to never do a project in ASP again (what a nightmare!).

------------------
Gil Hildebrand, Jr.
Senior Web Developer, 4atcost.com

Peter J. Boettcher — Sat, 15 Apr 2000 01:25:00 +0000

Gil,

Regarding the SQL License issue, I'm really not sure. I don't think it keeps track of how many users are using connections, it's more of a "good faith" type thing. Don't hold me to it but I'm pretty sure you can connect as many users as you want, it just wouldn't be legal as per the software agreement.

As for the ODBC question, you would setup a system DSN for SQL just like you would for Access, you could even keep the DSN the same so you don't have to change any of your ASP pages (make sure you rename/delete the old one). Your old SQL statements will work fine with SQL 7 (providing you kept the same database structure).

Now if you were connecting to Access via dsn-less connection (connected to physical .mdb file residing on your website) then you will have to change your connection method, but this isn't to much work (2-3 lines of code).

Regards,
Peter J. Boettcher

Gil — Fri, 14 Apr 2000 23:56:00 +0000

Peter, I have one more question. If I buy a 5 user license for SQL Server, what happens if a 6th person tries to access it, assuming I am using an ASP script for it. Also, will I be able to use ODBC for my database, as if it were the same as Access, or do I have to use different ASP commands specifically for SQL Server? Thanks a lot. I am just trying to make sure I get all of my questions answered before I spend a ****load of money.

------------------
Gil Hildebrand, Jr.
Senior Web Developer, 4atcost.com

Peter J. Boettcher — Fri, 14 Apr 2000 18:01:00 +0000

Gil,

SQL 7, can handle blobs, no problem. Make sure you use 7, 6.5 had some issues with blobs.

Peter

Gil — Fri, 14 Apr 2000 04:44:00 +0000

Peter, I am developing a site in Access right now, but I am seeing the need to switch over to SQL 7 because I need data strings longer than 255 characters. In SQL 7, is there support for a BLOB like in MySQL?

------------------
Gil Hildebrand, Jr.
Senior Web Developer, 4atcost.com

josemontesjr — Tue, 04 Apr 2000 15:10:00 +0000

Thanks, this cleared up the smoke a little.
SQL 7 also has a graphical user interface?