Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by iwanalearn

  1. iwanalearn

    mysql to mssql "order by"

    Thanks vongrunt. Works great now.
  2. iwanalearn

    mysql to mssql "order by"

    I have a database that searches for dealers based on the zip code entered. I want the results to show the dealers with the same zip code on top of the list then alphabetical after that. We have switched from mysql to mssql. Learning mssql but need help converting this code. This is how I sorted...
  3. iwanalearn

    Summit48 Power up no led's on front panel

    OK, I found the solution on a different forum. What I needed to do is pull the power cord from the unit. They suggested 1 minute. That wasn't long enough. So, I pulled it for the weekend. Plugged it in and away it went. I also found out that you can't do a reboot with the web interface it's a...
  4. iwanalearn

    Summit48 Power up no led's on front panel

    I was in the process of changing the IP address of my summit48. I accidentally turned the power off. Now when I turn the power on none of the led’s on the front light up and I can’t get the console to connect. What can I do? Thanks
  5. iwanalearn

    CheckBox Display in Crystal Report

    It seems to work in all situations. What would be the better soloution? Thanks
  6. iwanalearn

    CheckBox Display in Crystal Report

    I figured it out: IF (Count ({JobSpecPrepress.Work-Center-ID}))>=1 and {JobSpecPrepress.Work-Center-ID} = "100" and {JobSpecPrepress.Operation-ID} = "100" then chr(254) else chr(168) Works Great. Thanks to all
  7. iwanalearn

    CheckBox Display in Crystal Report

    I just did some more checking and found that the boxes do not show when I have more that one subjob. Example: One subjob 100 100 = checkbox "" "" = blank box two subjobs on one job subjob1 100 100 = nobox subjob2 100 100 = nobox I guess what I need to know is how can I consolidate multiple yes...
  8. iwanalearn

    CheckBox Display in Crystal Report

    I've been trying to get the blank check box to show. Here are the 2 formulas I tried stringvar formula; if {JobSpecPrepress.Work-Center-ID} = "100" and {JobSpecPrepress.Operation-ID} = "100" then formula := chr(254) else formula := chr(168) and if {JobSpecPrepress.Work-Center-ID} =...
  9. iwanalearn

    Truncate all text after ,(comma)

    Thanks for the quick response. It works with with all the suggestions. Thank you
  10. iwanalearn

    Truncate all text after ,(comma)

    Yes, I'm a new crystal reports 9.0 user. I have 5 field that import some have data in all field and some only have data in the first field. I read The Comlpete Reference, but couldn't relate to what I want to do. Example of what prints John,John1,John2,John3,John4 or John,,,, all I want is...
  11. iwanalearn

    body_checks

    Thanks for the responses. Actually I found something that does work well. I've been using the following. /www.*test.*com/ REJECT I found this on a different forum. Yes I do have regex built into postfix. Again Thanks
  12. iwanalearn

    body_checks

    I'm just learning linux/postfix/etc. I've been working with body_checks to stop the flow of spam. It seems to work for me with one exception. I can't get any phrases with a "period" to be rejected. e.g. /www\.test/ REJECT Spam /www.test/ REJECT Spam Neither of these works to stop www.test.com...
  13. iwanalearn

    httpd.conf what am I doing wrong?

    Chuck, Yes I do. actually it is like this <IfModule mod_dir.c> DirectoryIndex index.html Home.php Chamber.php Splash.php </IfModule> Do I want to put this with each Virtual Host since each has a different home page? Also, this information is found above the Virtual Host part. Do I need to...
  14. iwanalearn

    httpd.conf what am I doing wrong?

    Yes I'm new to apache. I have virtual websites on an NT server. I'm moving them over to Suse 9.0 Linux box. I've followed the instruction found here and this is what happens. If at a browser I type in the web address www.mysite.com I get an index list of the folder on the webserver. Same thing...
  15. iwanalearn

    Server crash, Exchange will not connect to server.

    My Exchange server crashed and this is the message that pops up when I try to connect to the server. &quot;A connect could not be made to the Microsoft Exchange Server Computer&quot; &quot;A code page required for character translation to and from unicode is not installed on this computer&quot...

Part and Inventory Search

Back
Top