Search results for query: *

ok, I tried all these tricks. I found that if I put the textbox in the detail section of the form it works fine. The section it was in was one that I made up.

Yep, the can grow is set to use for the section. Still the same. I wonder if that is not the correct control to use for a memo field. Shouldn't there be a text area control or something?

Nope, neither of these are the problem I have checked both. For some reason the textbox control on this report wants to truncate the data that is stored in the memo field in the table. When I open up the table, all the data is there but when I try to display it in a textbox control on a report...

I am using a text box control on a report to display data that is stored in a memo field in one of my tables.... but for some reason it cuts off after a certain amount of characters. EX. My table has a memo field with lets say 15000 characters in the memo field. When I try to display this in a...

Thanks Danno I have seen live stats. I was looking more along the lines of free. I am poor. Any other suggestions.

Plus I would also like to track any other connections to this machine.

yes but there is no guarantee they will click the logout button which would record the end time.

Hi there. I was wondering if anyone might know of some software to keep track of who(ip address) is connected to my web server and for how long etc. I am using iis 5 with sql 2000 and asp pages that are used for members to login and do stuff.... But I was wondering if there was someway of...

thanks fluteplr. It makes sense that it would save time. I just wasnt sure how much time or if it would matter. I am still in sql tsql "training". I need to take some more courses on this stuff but they are far and few in the area I live in. Thanks Bryant

yes that is exactly it. Thank you very much. I appreciate it. Once I saw your answer I was like duh.... Thanks Terry.

You might want to try a join condition on those 2 tables rather than selecting from 2 tables that way.

That is the correct statement for a not equal condition. The select from is what is bothering me. I am not sure what you are selecting from.

I was going to write a stored procedure that gets passed 5 values. These values may or may not have changed from what they currently are in the tables. What I was wondering is... Should I compare the values being passed to the procedure to the values stored in the tables or should I just update...

I enclosed my parameters in brackets as suggested and I got the following error Item cannot be found in the collection corresponding to the requested name or ordinal. It seems to work fine without Bryant

ok I think I got it figured out. I just thought I would post to let you know how I got it to work. I had to create a system dsn. At the current time I was only using a file.dsn. I had to go to Control Panel Select Admin tools then ODBC Source Admin. Then I had to select System DSN. hit add...

I am getting this error. Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified /MCERegister/User/frmCurrentTermtest.asp, line 2605 Here is the contents of line 2605 cn.Open...

ok tks Paul I will post back to you on Monday

I am using sql server 2000. MCERegister is my dsn. I have no idea of how to form a connection string could you help me with this. Maybe you have an example with explanations.

I have tried this but cannot get it to work. Is this similar to what you had or am I way off. I dont understand what some things are in your example such as cm.CommandText = "SaveBidderImage" cm.ActiveConnection = activeconnection cm.CommandText = "SPName" cm.CommandType =...

yes that is exactly what I need to do I just need to pass 4 parameters to a stored procedure and thats it. Would you be able to give me a better example of how to do that. I have just been using recordsets to pass values to a stored procedure because I am just learning and did not know how to...