Search results for query: *

Thanks for response I fiqured that out.

How can I chage the Id#'s lengh. when an item is enter it generates an Item Id such as this one #50034822521100004. Is there any way I can change this long number to 6 or 7 digits. I tried to change Text in database to number field got error. tried to change field to 7 or 10 instead of 50 got...

Thanks chris

I don't know much asp no end sub. Chris. what that means. should I add end if after sub carryOn ?? thanks

This is the error: Error Type: Microsoft VBScript compilation (0x800A03EA) Syntax error /awgal/vote/Stats.asp, line 36 sub carryOn line 36 is in red Set Myconn = Server.CreateObject("ADODB.Connection") Myconn.Open DB_CONNECTIONSTRING SET MYTABLE= SERVER.CREATEOBJECT("ADODB.RECORDSET")...

anyone knows how to display poll results in the same page as voting page. this is in Asp runing with access databse. I tried to use included file <!-- #INCLUDE FILE="stats.asp" --> but I get error. any suggestions. thanks

Thanks glen for your input database is Access database (ASP). I am trying to get as much info. as I can to set this up. I am new to all these, trying to learn it.

Thanks drexor for reply I don't know much about programing or writing script. do you have a source you can direct me to showing how to do what you have recommended.

I am trying to setup following code to delete records from data base after 30 days: DELETE * from table1 WHERE DateDiff("d", table1.Date, Date()) >30; questions: 1. will this code do the job 2. If so where this should be placed. should it be place where record is inserted. please give an...

Also I forget to ask if date/time could be a problem. I read somewhere that date/time is updated automatically when record is updated.

thanks Tarwan the ID is autonumber and ItemId is text with field text of 50. ItemId generates autonumber when itemes are entered. is up to 10 digits. This is the actual number it generated when a position was posted (Sales position #290654610) this number corespond to ItemId. Is it possible...

Thanks Genimuse for your help. I checked the table fields, they seem to be ok 50. 100, 200. I tested with only few words, still not working. This runs ok on my localhost and old server I had but not on window 2003 server that I recently signed up with. I am not sure with the problem is. thanks...

Thanks for your help this is my Ads table: ID AutoNumber ItemId Text (generates atuo nnmbre field size is 50) Position Text Description Memo MUrl Text ContactName Memo Email Text...

except ItemId all are text filed. When I run the sql as you said it gives me this error: Data type mismatch in criteria expression. when I check help button this is what shows: The window name "langref" passed to HH_GET_WIN_type has not been specified. I don't know what these mean!

yes ItemId is is autogenerated number. This is what I get with response.write looks fine. except error UPDATE Ads SET ContactName ='ben', Qualifications ='BE/BC, Experience is a plus but not Rquired .', Url ='http://www.pbpr.com', Position ='sale', Goal ='see detail', Email ='ali@msn.com'...

Does anyone knows how to update specific record from database; for example a user sign in and would be able to update his/her own records only. I use dreamwaver to set up update records but this will pulls all records in the table and user will have access to everyone records in that table to...