Recent content by thelobe

Hi all, I wonder if anyone can help me on something.. I need to import email addresses from an exchange server into our own database. Does anyone have some sample code to demonstrate how I would go about retrieving a list of emails from a microsoft exchange server? Any help would be greatly...

Hi all, I wonder if someone can help me set up awstats on IIS 5, or even give me a link to a site that explains this step by step. I am new to this... Please help

Can anybody please tell me what syntax to use when using the LIKE statement in Stored Procedures. This is my code, which doesnt work :( CREATE PROCEDURE dbo.Test @STR_IRC_DESC varchar(50) = 'b' AS SELECT * FROM TBL_IRCS WHERE IRC_DESCRIPTION LIKE % @STR_IRC_DESC % GO Please help Thanks

Hi, I seem to have a little problem with SQL server, regarding the order of data being displayed. I cant paste the code, but when i display data on an ASP VBScript page, and the piece of code that retrieves it is at the bottom, it does not display the data AT ALL, but when i move it up, before...

Uhm, see, TBL_USERS.USER_ID is an int, and TBL_IRCS.IRC_ASSIGNED_TO is an int, and TBL_USERS.USER_NAME is the varchar... I just had to think a bit more :P This is the code that works SELECT ASSIGNED.USER_NAME AS ASSIGNED_USER_NAME, RAISED.USER_NAME AS RAISED_USER_NAME FROM TBL_IRCS inner...

Nevermind! Got it working! :-) Thanks alot!! I think i need to learn joins...hehe

Hmmm, okay, i see what you mean. I tried the code and i got this Syntax error converting the varchar value 'PTT Administrator' to a column of data type int. I realised that in TBL_IRCS the value of IRC_ASSIGNED_TO is an int, i.e. the USER_ID, not a varchar.... What now?

Thanks for the response! Creating two user tables would solve the problem, but that isnt an option, not in this case anyway. I am not familiar with joins, they look to complicated to me :P isnt there some other way?

Hi, I seem to have the same problem as tekdenied, only thing is, i do not use 1, 2, 3 or 4... What basicly happens is, i need to get user names from a table. But the IRCs table has two columns which use user id's, and i need to return different user names from the users table... This is the...