Do You Hate Your Job?
If You Are Like Me And REALLY Hate Your Job, You Can Do What I have Done And
Tell All About Your Company At A Great And CHEAP New Site Called
Dont Work For These . Com

http://www.dontworkforthese.com
This Site Has Chat Rooms,
A Joke Section,
A Great Story Section Where You Can Tell All The Funny Or Stupid Things That
Happen Or Have Happened To You During Your Working Day.
Work Forums For You To Ask And Reply To Questions
And Do Not Forget You Can Tell All About Your Terrible Treatment You Endure
While Trying To Make A Living.
Best Of All They DO NOT Want Your Credit Card Details In Order To Join.
You Pay Through PayPal

Hi all
I'm working on a rooms reservation system based on Access 2003 and then
realize an ASP web page to manage it.

I need a little help in creating the DB since my ideas aren't so clear.

First of all what I need is very simple:

- I have two rooms and I have to let user reserve time slot of 15
minutes each
- every day has 8 slot
- a user can't book more than 1 slot per day

I thought to realize a DB with this structure

- 1 table with ID,DATE,ID-CUSTOMER
- 1 table with ID,NAME,SURNAME,PHONE,ID-SLOT
- 1 table with ID,SLOT

then I connect the first table with the second, and the second with the
third...

but I'm not sure... am I in the right direction?

anyone can help me?
thanks

here is a simple form. it works well in my system. I hosted my site. but i
get the error
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

/join.asp, line 57

i've highlighted the line 57. pl. help me. without this fix, i cannot tell
anybody abt my web site.

thx in advance

Hello,

Right now I have a full text search going like this:

SELECT top 25 id, question, answer from [answers] WHERE
CONTAINS(question, '""" & search & """')

where "search" is the variable holding the form value the person typed
in.

the problem is, it only finds exact matches. For example, if williams
does not match william's, william does not match williams, etc

is there a way to make the search more useful?

Thanks for any help!

-Mike

Hi all
I'm trying to get information about a way to read an XML file within an
ASP page an then save data into an Access table...

Thanks for your support
Paolo

Hello,

The code below results in a reported syntax error near the keyword "Select".
I copied most of this from a perfectly functioning application I worked on a
couple of years ago, that still works, just changing the references. I can't
see what it is referring to. The line number listed in the error message
references the open statement directly.

Dim rsCodes, strSelect, strEMsg, strLevel
Set rsCodes = Server.CreateObject("ADODB.Recordset")
strSelect = "SELECT * from MemberCodes WHERE code = '" & strCode & "'"
rsCodes.open strSelect, objConn

The objConn is set up in a connex.asp included file at the beginning of the
page:

Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=SQLOLEDB; DataSource=****; " & _
"Database=*****; User ID=***; Password=*****"

I tried replacing code 1 with code 2 below on a busy web site (mssql2005,
iis7). The page failed when busy however giving the following error:
Connection is busy with results for another hstmt. Can anyone suggest how
this scenario can be altered to cope with many requests?
Thanks SOC.

=======================================
code 1:

Set dbconn = Server.CreateObject("ADODB.Connection")

dbconn.open "DSN=dsn;UID=uid;PWD=pwd;DATABASE=db"

Set rsin2 = Server.CreateObject ("ADODB.Recordset")

rsin2.open "Exec sp_subnav '"&catid&"'", dbconn

========================================
code 2:

Set dbconn = Server.CreateObject("ADODB.Connection")

dbconn.open "DSN=dsn;UID=uid;PWD=pwd;DATABASE=db"

I can't seem to figure out how it's done. I know it has to be something
fairly simple.
I know how to open an excel file, but I'd like to open it, insert values and
save it with a different name and password protect.