ofisboy

I think I'm going to go ahead and move to the SQL server and give it a shot. As luck would have it, my ISP does have a web interface so I can take care of the management myself. I think it's time I learned. Thanks so much for all your help.

I have absolutely NO familiarity with SQL but would like to try it since I've read that it is superior to the database driven sites I currently have. I can move to an SQL server. What would I have to do to make that transition? Is there some conversion process I would need for the database or would I be starting from scratch? Hmmm ... sounds like I'm rambling because I don't know what I'm talking about so it's up to you to interpret what I'm thinking and NOT what I'm saying!

Here is the format I used with both the select and delete lines: sSQL = "Select * FROM CDListing WHERE CDListingID = '" & lID & "'" SQL = "Delete * From CDListing where CDListingID = '" & lID & "'" Here is the new error I am receiving now: Microsoft JET Database Engine error '80040e07' Data type mismatch in criteria expression. /deleteconfirm.asp, line 28 Did I get the format wrong? I have purchased numerous scripts (both cgi/perl and asp) for different web sites I have created and only know enough to make minor modifications to the scripts, so please bear with me. Out of curiosity, would you please explain to me the advantages of cgi/perl over asp? I just purchase scripts based on what features they offer and not on any kind of technical expertise. Thx again.

I am trying to delete an item from a web site via a database but I'm getting the following error: Microsoft JET Database Engine error '80040e14' Syntax error (missing operator) in query expression 'CDListingID ='. /deleteconfirm.asp, line 28 Here is the script. Does anyone see a problem? I can't for the life of me figure it out: <% strUserName = session("UserName") strAction = request("cmdAction") 'strSortType = request("SortType") 'strSortType2 = request("SortType2") lID = request("ID") If lID > 0 Then sSQL = "Select * FROM CDListing WHERE CDListingID = " & lID Set rsSearch = objADO.Execute(sSQL) end if if Request.Form <> "" and strAction = "Delete Listing" then ' Create a recordset object to store specific table information Set RSSearch = Server.CreateObject("ADODB.Recordset") 'Establish what records you want selected for the SQL query string SQL = "Delete * From CDListing where CDListingID = " & lID 'Set the recordset object equal to the SQL query string RSSearch.Open SQL, objADO, 1, 3 Response.Redirect "listingdeleted.asp" end if %> Any light you can shed is appreciated and thanks in advance for your help.

YAWN...whatever.

Let's see...I ask a ligitimate question in a nice and polite manner, then I reply that I have resolved my problem...also in a nice, polite manner, then I receive an uncalled for sarcastic comment. So what clutch is telling me is that apparently it's ok for senior members to be impolite, sarcastic, or any other inappropriate behavior, yet junior members need to feel justified? Interesting psychology. You're right in saying that not everybody uses ICS but someone here probably does...and if not, so be it. No answer is certainly better than uncalled for sarcasm (although I do appreciate the second message from Uykucu...it was a network problem and not ICS.). I read just about every post in here and enjoyed the help offered and picked up some good tips for myself, so needless to say, I was surprised by the sarcasm. Would clutch have let a sarcastic remark go by without commenting? Obviously, not...he responded to mine. I also requested information in the "Drivers" area regarding the Genius graphics tablet. I didn't get a response because there probably aren't many people who use that tablet, so when I found the correct driver I posted the link for others who might need it. I seem to be doing my part in this forum but for some reason, clutch wants me to be the bad guy. Huh...go figure. Time to let this drop. It's not worth anyone's time or effort. Regards... Cheryl (aka ofisboy)

I had been reading those menus for two days. Too bad they didn't address the problem I was having. I'd tell you about it but you're obviously not interested. I naively thought I would get some help here but I must have misunderstood this forum's intent...but gee, the next time I want to debate who has the best/worst hardware, I'll be sure to come back.

Never mind...I got it.

I know this is elementary to most of you, but as a brand new Win 2000 upgrader, I am having trouble figuring out how to set up my network and internet connection sharing. I've tried so many different things now that I can't tell you what I've done and what I haven't. I appear to be able to access both the host and client from each other indicating the networking is ok, but I can't get the internet connection sharing to work. Would somebody please offer a clue to this newbie?

Here is a new link for the Genius Easy Pen and Easy Pen Pro Win 2000 drivers: http://www.genius.mu/geniusasp/drivers.asp?Id=3

Oops...I originally put this under Win XP. Does anyone have any idea where I might find a Win 2000 driver for the Genius Easy Pen? The link on the main site (http://www.ntcompatible.com/gb.shtml) is no longer valid. I've searched all over and it seems to have disappeared into oblivion. Any clues? Thanks...

Does anyone have any idea where I might find a Win 2000 driver for the Genius Easy Pen? The link on the main site (http://www.ntcompatible.com/gb.shtml) is no longer valid. I've searched all over and it seems to have disappeared into oblivion. Any clues? I'm not sure if this is a hardware or an applications question so I'll throw it out here for starters. Thanks... OB

I'm only researching driver compatability prior to upgrading to Win 2000 so I really know nothing about it, but is it possible the monitor going blank after awhile could be something as simple as having Power Management functions turned on? Huh...I don't even know if there is a Power Management function in Win 2000 but it was just a thought. Regards, OB