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!

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

Search results for query: *

  1. Clanger67

    Searching for name that can have 1, 2 or 3 parts

    I have checked that thread, but when trying the suggested code it throws an error
  2. Clanger67

    Searching for name that can have 1, 2 or 3 parts

    ...[dbo].[spGetContactFromContactName] @contactname VARCHAR(200) AS DECLARE @searchstr VARCHAR(200) set @searchstr = '"'+REPLACE(@contactname,',','*" OR ''')+'*"' select * from tbl_ContactDetails where contains(Full_Name,@searchstr) This works, but only in certain circumstances. If the field...
  3. Clanger67

    Error changing server name

    Thank you jpadie and ingresman for your suggestions. The solution was updating the ntwdblib.dll from versions 2000.2.8.0 to 2000.80.194.0 in the C:\php directory. Once I did this the code ran with no errors
  4. Clanger67

    Error changing server name

    We are having to move our database from its original server onto a new one. Both servers have MySQL and SQL 2000 on them. They both have the same version of the ntwdblib The only file I can find where the old server is named is in the dbconn echo "<!-- Detected site 89.0.x.x -->"; define...
  5. Clanger67

    Get ID of textbox when checkbox has been selected

    I have a page where when the user clicks on a checkbox I want the text box next to it to become enabled so the user can edit the data inside it. The checkbox has a unique reference number assigned to it from a database record. There could be up to 5 or 6 checkboxes on the form at the same time...
  6. Clanger67

    Creating Where Clause based on variables passed to stored proc

    Mark and RiverGuy Thanks again and I will go and have a play with the CASE WHEN and see how I get on Cheers David
  7. Clanger67

    Creating Where Clause based on variables passed to stored proc

    Thanks for your reply RiverGuy but I was trying to do something similar to what is shown here http://www.sqlservercentral.com/articles/Miscellaneous/howtobuilddynamicstoredprocedures/968/ David
  8. Clanger67

    Creating Where Clause based on variables passed to stored proc

    I have a stored procedure into which I want to pass variables and depending on the value of the variable passed into I want to be able to change the Where clause. I keep getting an error: Incorrect syntax near the keyword 'WHERE' Any help would be much appreciated @InvoiceStatus AS Int...
  9. Clanger67

    Show the Printer Dialog box

    I have a checkboxlist on my aspx page. When one of the boxes is ticked I want to be able to display the print dialog box is this possible and if so how. Thanks in advance David
  10. Clanger67

    Sending FAX from Visual Studio 2005

    I have a web page with a button on and when I click I just want to send a fax. The code I have, which I found by browsing on the net is pasted below. It works fine until it gets to the .send part and then I get the following error: The handle is invalid. (Exception from HRESULT: 0x80070006...
  11. Clanger67

    Div Not Scrolling in Firefox

    Jeff Thanks for the tip about Firebug. I have installed it and it points to the following line as being the problem. eval(docStyle + objectXY + styleDoc + horz + "=" + x); This is the error message that Firebug is giving document.divHelp has no properties valMove()floathelp.js (line 54)...
  12. Clanger67

    Div Not Scrolling in Firefox

    I have created a Div that displays help text when a user clicks on a textbox, checkbox, radio button etc. The Div then scrolls down the left side of the page, keeping it at the top. It works fine in IE 6 and 7, but I cannot get it to work in Firefox. It just sits there. I have posted the JS...
  13. Clanger67

    Floating Menu

    Dan Sorry for not posting earlier, but I was away on Friday. I have since found another solution and have managed to get that to work. I can post you a copy if your interested. Just like to say thanks for all your help and patience. Thanks once again David
  14. Clanger67

    Floating Menu

    Dan Lots of hair pulling....not that I had much to pull in the first place [afro] David
  15. Clanger67

    Floating Menu

    ...var step_x, step_y; alert('line 61'); compute_shifts(); alert('line 64'); step_x = (fm_shift_x + target_x - fm_next_x) * .07; if (Math.abs(step_x) < .5) step_x = fm_shift_x + target_x - fm_next_x; step_y = (fm_shift_y + target_y - fm_next_y) * .07; if...
  16. Clanger67

    Floating Menu

    Yes I did Dan, it hasnt worked. I didnt see your last post until after I had put up my last post. Thanks again David
  17. Clanger67

    Floating Menu

    ...} function float_menu() { var step_x, step_y; compute_shifts(); step_x = (fm_shift_x + target_x - fm_next_x) * .07; if (Math.abs(step_x) < .5) step_x = fm_shift_x + target_x - fm_next_x; step_y = (fm_shift_y + target_y - fm_next_y) * .07; if...
  18. Clanger67

    Floating Menu

    Dan Have tried adding the extra function and line of code, but still no luck. The <div> displays fine on the page, it just doesnt move. I am not getting any errors on the page, its as though the page isnt seeing the js file. Not sure what you meant by recalculating the variables. Thanks for...
  19. Clanger67

    Floating Menu

    ...} function float_menu() { var step_x, step_y; compute_shifts(); step_x = (fm_shift_x + target_x - fm_next_x) * .07; if (Math.abs(step_x) < .5) step_x = fm_shift_x + target_x - fm_next_x; step_y = (fm_shift_y + target_y - fm_next_y) * .07; if...
  20. Clanger67

    Floating Menu

    ...var fm_shift_x, fm_shift_y, fm_next_x, fm_next_y; var step_x, step_y; compute_shifts(); step_x = (fm_shift_x + target_x - fm_next_x) * .07; if (Math.abs(step_x) < .5) step_x = fm_shift_x + target_x - fm_next_x; step_y = (fm_shift_y + target_y - fm_next_y) *...

Part and Inventory Search

Back
Top