Search results for query: *

...I use is: SQL Server 2000 Developer's Guide, Osborne, ISBN: 0072125691 You might want to take a look at Chapter 17, Developing Applications Using DTS. DTS is a good tool and it's hard to find good docs about using it. John ********************* John Nyhart www.nyhart.com *********************

...But, if you really need to do this then you need to find out the max length of any word (don’t forget to TRIM the blanks). Then after you know this value then you can resize the field. It would be a two step process. John ********************* John Nyhart www.nyhart.com *********************

...Some functions could become stored procedures while others could be turned into triggers. If the function is very complex then you will have to handle it on the client side (after retrieving the recordset as raw data). John ********************* John Nyhart www.nyhart.com...

I just notice that this would require that there were records for the customer in all four tables. This may not work ..... try 'HAVING' .... John ********************* John Nyhart www.nyhart.com *********************

...d WHERE a.customerNo = b.customerNo AND a.customerNo = c.customerNo AND a.customerNo = d.customerNo GROUP by a.customerNo, a.name ******************************************* If this doesn't work then look at the 'HAVING'. John ********************* John Nyhart www.nyhart.com...

...of CF. I see that I could get the Data Area through the Toolbox with Java. I also have heard that the new MX server will let me see return values from a SP. If this is true then I could use a CL. Just thoughts ...... John ********************* John Nyhart www.nyhart.com *********************

...anyone know if MX can directly get into AS/400 Data Areas without using Java Toolbox or some other method? I have a project coming up that I need to get into the Data Area and just doing some up-front digging. Thanks, John ********************* John Nyhart www.nyhart.com *********************

Thanks ..... I have never needed to schedule before and was unaware of this tag. John ********************* John Nyhart www.nyhart.com *********************

...file and FTP's that file to my desktop. I need to start this process every hour. What sort of processes that you have come up with to do this? Java Script or VB from the desktop? Thanks, John Webmaster Venetian Hotel/Casino ********************* John Nyhart www.nyhart.com...

...as Expr1 from tblBOM WHERE tblBOM.JobNo = " & JobNo If JobNo is a string then it should look like this: sqlmax = "SELECT Max(BubbleNo) as Expr1 from tblBOM WHERE tblBOM.JobNo = '" & JobNo & "'" John ********************* John Nyhart www.nyhart.com...

Hi, I believe that you need to use an outer join. John ********************* John Nyhart www.nyhart.com *********************

...in a variable and the statement would look something like this. Search_Var = “RPG” SELECT Field1, Field2, Field3 FROM Tab_Name WHERE Field1 LIKE “’*” & Search_Var & “*’” OR Field2 LIKE “’*” & Search_Var & “*’” OR Field3 LIKE “’*” & Search_Var & “*’” The * is a wildcard symbol and it...

Hi .... If I hear you correctly you can do this with sub-selects. Something like this: Select (Select statement for Index 1) as number1, (Select statement for Index 2) as number1, Etc..... FROM ..... HTH, Regards John ********************* John Nyhart www.nyhart.com *********************

...the client name without the non alphanumeric characters and then on the second pass you can do the LIKE statement. With the fast CPU’s that we are now using this will only be a few seconds of wait for the client. Regards, John ********************* John Nyhart www.nyhart.com...

You are close. First you need to fix Count(*) to a real field name. Second you need a WHERE clause in your UPDATE statement. Something like this ….. UPDATE T-Sellers SL SET NumOfSales = (SELECT Count(SA.anyField) FROM T_Sales SA WHERE SA.Seller = SL.ROW_ID)...

Ahhhhhh ..... perfect. Thanks ..... John ********************* John Nyhart www.nyhart.com *********************

...<a class=&quot;details&quot; href=&quot;/casino/vpc_grazie.cfm&quot; style=&quot;text-decoration: none&quot;><img src=&quot;assets/click_for_details.gif&quot; width=&quot;67&quot; height=&quot;10&quot;></a> Thanks .... John ********************* John Nyhart www.nyhart.com *********************

Carl .... your the man of the hours ..... thanks to both of you for the help ..... it now works. John ********************* John Nyhart www.nyhart.com *********************

...then one words. Like: Green Cars. The problem is when I evaluate the FieldName(s) that are sent I only get Green not Green Cars. Here's the code. ************ SELECT CODE ************************** <select name=fieldFrom size=5 style=&quot;width:120;&quot; multiple> <cfif...

Hi .... I guess that you have lost me in what you are trying to get as results. .... did the web site about two years ago .... all the movement is done with CSS. John ********************* John Nyhart www.nyhart.com *********************