Recent content by Holmer1

How do you re-associate the queue with the printer?

I have a problem printing to my novell printer. When I looked the Queue had been removed (not sure how) . I have re-added the queue and when I send jobs I can see them lined up in the queue but they are not being directed to the printer. Can someone help me with how to re-direct this queue to...

I have been successfull using a combination of the LTRIM and RTRIM commands within my result set and my sql query. Thanks to RileyCat, Tleaders, and MDXer.

Yes , RileyCat, I think you are right. I have it working in my query analyzer but still have something wrong in my asp page. I have used the LTRIM on the variable so it is only 1 char long in this case. I passed this into my sql statement and used the LTRIM on my table column. eg. MCU=...

Is there anything else I can use in the place of Replicate?? I get a type mismatch when I do this. Type mismatch: 'REPLICATE'

What I really ant to do is add the leading 11 spaces to the value returned , in this case 3, so that the field is 12 characters long and when I plug it into my sql statement I will ge the right results. I was hoping to use something that would say if this field is 1 character long then add 11...

I am trying to pass a value into an SQL statement to retrieve a result. The value I pass is from a varchar field and has a length of 12. The value I retrieve for a table for example is 3 . When I try and pass this value into my sql statement it gives me no results because the field is actually...