Search results for query: *

...= ItemList(theBoxNum+1) thePrice = theItem(theBoxNum/2,2) theQty = theItem(theBoxNum/2,0) theItem(theBoxNum/2,3) = thePrice*theQty Next End Sub function ProductSelected() DIM theBoxNum,theLineItem, theLineHead, theLineTail, TableCode, thePrice, theQty TotalValue = 0...

Hi Everyone, I just started learning ASP and wrote my first .asp file in FrontPage...But When I tried to do the preview, the part which was written by using ASP did not show and I did not have either compile error or run time error. I could not figure out why. Can anyone kindly take a look at...

Hi, I create a web page with list of items, the user can select the items and click on "continue" button and go to the next page. In the new page, the items user selected will be listed. I have a update button in the new page, which user can use to cancel the items they selected. All...

I have just figured out what is wrong with my code. I should use eachItem(i) instead of eachItem(i).value. It is working now. Anyway, thank you very much for you help

Thank you so much, dilettante, for you help. I would give you another star if I could. Most parts of my script is working now. The only problem I have now is that in my second page, I used the following code to get the string, which is pass over by using code: document.location.href =...

Thanks PH., I have tried your way but still get the same error message, I think there is something wrong about syntax of that line of code...I am digging into it now and hopefully I can find something. Thanks for your help. Really appreciate it.

Hi Dilettante, Thanks for your help. Can you take a look the code and see what is wrong? I kept getting error message at line: document.location.href ="MyPaymentPage.htm?theName(index) =" &Name(index) ";theValue(index) =" &Value(index). The error message is: expected end of...

try this and see if it works Dim worddoc worddoc = createobject("word.basic") worddoc.appshow worddoc.filenew worddoc.Insert "Hello World"

Hi Everyone, I don't know if my question should be posted here. But I thought I give it a try. I am trying to use VBScript to develop a webpage (this is a just a way for me to learn VBScript and I never develop any webpage before, therefore, I thought I may learn them all together). My...

Hi Everyone: I have two exact the same databases in the same server with different names, Now I want to transfer one table's data from one database to the other. I know I can use dts to do the data transfer. But I want to know what other options I have to transfer these data? Can it be done by...

Thanks guys for your help!

Hi Everyone: I am adding a job to MSDE. But as I understand, in order for the job to run, agent must be started and running. Since MSDE does not have EM, how can I tell if the agent is running? if it is not, how to use T_SQL to start the agent? Can anyone kindly give me some help? Thanks alot

Thanks Sunila7. I have tried to change the connection to my database to Single User Mode...but I could not change it by using alter database command when there are multi connections currently connecting to the database. Can anyone please give me more suggestions? Thanks...

Thank you Kudithipudi for you reply... I have already checked that option. I think it does not fit my situation. "-m" switch is used for when you just start your database. But my situation is that my database is already started and running in multi_user mode.

Hi Everyone: I need to modify my database, such as adding some columns and moving some data among tables...I have written T_sql code to do this...my question is that when I am running my sql code, I need to stop all current connections to my database and stop user from reading from or writing...

oops...I did not mean that my way is the best...all I am saying is that using DTS is the easy way to move data around...I totally agree with you SQLsister...But he does need to move all Access data to the SQL server...

If you already have SQL Server installed in your machine, I believe that the best way to move your Access2002 database to SQL is to use DTS, you can create a empty database in SQL and use DTS to transfer all the data from Access to SQL or even better that you can create a new database on the fly...

Thank you, topher0303,sguslan and nikhilparchure for your very helpful input. I added one more covering index on the table. So there are totally one clustered index and two nonclustered covering indexes. It works well. Thanks alot...

Hi Everyone: I have a table,which has been used in several queries. I have created one non clustered covering index,which covers all the columns retrieved for all the queries,besides the clustered index on the table...for each query, this nonclustered index is used. But for some queries, query...

Thank you clapag22 and sunila7 for your helpful reply...