Recent content by dgaylor

Is there a way to use filestream to read a text file in as hex. Instead of reading in each character and converting to hex I am hoping that there is a built in method. Thanks.

is there a way to use filestream to be able to read all hex values. for instance i am getting 8 spaces instead of hex 09 for a tab character. thanks in advance.

Never got an answer but for my purpose I just wrote the following code. Thanks. update email_table set good_email = 'Y' where (CHARINDEX(' ', LTRIM(RTRIM(email_address))) = 0) AND (LEFT(LTRIM(email_address), 1) <> '@') AND (RIGHT(RTRIM(email_address), 1) <> '.') AND...

Select col1, col2, (case when col2 = 'A' then col1 + col1 * .10 when col2 = 'B' then col1 + col1 * (-.08) else col1) as var from... where...

I need to validate email addresses that are already stored in my database using transact sql. I know how to use regular expressions to validate the structure of the email address using VB Script, but not how to do it in transact sql. Can anyone help me? Thanks.

i read that you should try to use response.expires=-1500. you can't rely on =0. -1500 means 25 hours ago.

yes, iis 5 comes with win2000 on professional and server. we are using professional.

i think this is what you are looking for, put this in the formula next to the suppress box:<br><br>if length(TrimRight({tcandidate1.city}))=0 then true else false<br><br>hope it works for you.

look here: <br><A HREF="http://www.hammerman.com/techtips70.html" TARGET="_new">http://www.hammerman.com/techtips70.html</A>

The following should work:<br><br>NumberVar Comma;<br>Comma:= InStr ({GENERAL_PROFILE.INDIV_NAME},',');<br>if comma &gt; 1 then<br>&nbsp;&nbsp;&nbsp;&nbsp;if Length({GENERAL_PROFILE.INDIV_NAME}) &gt; comma + 2...

this might also help you out with the headings:<br><A HREF="http://www.hammerman.com/techtips66.html" TARGET="_new">http://www.hammerman.com/techtips66.html</A>

well, Just recently i needed to create a report that listed counts for the last 12 months, or for the last 13-24 months, or for 3 month / 6 month / 7-12 month / 13-15 month (this causes the headers and number of header columns to change for the same report). The report also had to be by...

From my experience you will need to either use formulas for each of those columns (are each of the rows the same type of info?), OR if you are using a vb front-end or such then create your own ado recordset with the data already manipulated and create the crystal reports using active data (this...