Search results for query: *

Ok .... If you are going to use SQL Server then the book that 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...

Hi, Not sure why you would want to do this. Char string space only uses what it needs in Access. Even if you had a field with the length of 255 and you had only one record with a three letter word you would only use 3 chrs for that record. Access is not a fixed database like db2. But, if you...

Hi Sandy, Depends on the complexity of each function. 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...

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 *********************

Hi, I don't have time to try this but you might want to.... SELECT a.customerNo, a.name, Sum(b.ordersPlaced) AS Orders, Sum(d.qtySold) AS Sales, Sum(c.qtySold) AS Returns FROM customer a, customerContact b, productReturns c, productSales d WHERE a.customerNo =...

Hmmmm ... your fired! <just kidding> Well I thought that it could be done for MX server is based on Java and not C which all previous versions 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...

Howdy, Does 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 *********************

Hi to all, I have a CF project that creates a XML 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...

Hi, A couple of items to look for. Does your statement work when you hard code a job number? Is your job number field a number field or a char field? You can shorten the statement to look like this: sqlmax = &quot;SELECT Max(BubbleNo) as Expr1 from tblBOM WHERE tblBOM.JobNo = &quot; & JobNo If...

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

Hi …. Your key word needs to be 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...

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 *********************

Hi, Sounds like you can’t do this in one pass. I would suggest that you create a temp table with 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...

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 *********************

Hi to all from Las Veges. The code below works, but the image has a box around it .... need to remove the box .... <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...

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

Hi to all …. I have a select list that I populate from a record set. I allow multiple selects. The form is sent to a processing template. The items on the select form can be more then one words. Like: Green Cars. The problem is when I evaluate the FieldName(s) that are sent I only get Green...

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 *********************