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

  • Users: andyfresh
  • Content: Threads
  • Order by date
  1. andyfresh

    How to display one result from a db result set at a time

    Hi Im currently trying to learn javascript and have used the following code followed by a second file containing a php script. The idea of this script is as follows - the php script pulls in a number of results from a database. I then would like the java script to help display only one comment...
  2. andyfresh

    scrolling through ajaxs results

    Hi all, Im currently a beginner with ajax and trying to modify this simple ajax example. What I would like to be able to do is when the next link, which is located at the bottom of the html is click I would like the ajax to find the next record in the sql results and then for it to display this...
  3. andyfresh

    display results from a database in javascript

    Hi, Does anyone know how to collect information from a database and then display it in an array built within javascript. These are the three pages I have currently: The first is the html page which will hopefully display the results. <html> <head> <script src="getcontents.js"></script>...
  4. andyfresh

    message screen saver script.

    Hi Most people have seen a script similar to the following which displays a list of messages like a screensaver in a text area box however does anyone know how to display these messages in the same screensaver format but not inside one of the text boxes? I dont mind if its in between a...
  5. andyfresh

    checkbox variable

    Hi all, Im sure this is an easy one just need some fresh eyes on the script. This script is a simplified one that im working on but the theory is the same. When the check box is clicked I would like the javascript to run so that the screen redirects to website.php along with the value from the...
  6. andyfresh

    pulling results of SQL into Java

    Hi, I need some help on some simple java. Basically what I would like to do is to run a SQL script and then the results from that script to be passed into Java. The code I currently have is: <html> <head> <meta name="GENERATOR" content="Microsoft FrontPage 5.0"> <meta name="ProgId"...
  7. andyfresh

    pulling a value from a text box

    Hi Im currently try to run this scrippt where by when the user clicks the delete button the function deleteline() function runs which will display the line id on the page. However I cant seem to get the lineid value to be sent to the broswer. Any ideas? Andy <SCRIPT id=DebugDirectives...
  8. andyfresh

    PHP calling a java script with a variant

    Hi, Im currently writing a php script which has a hidden text box which contains a value pulled from a sql query which I know does return a result. When a check box is clicked a java script function is called which refreshes the page with the value in the hidden box becoming a variant. The...
  9. andyfresh

    Pie chart GD

    Hi, Im currently trying to add a pie chart to my website using GD. However when I run the following script the error Parse error: parse error in c:\inetpub\wwwroot\rateit\image3.php on line 2 comes up. I have used the following script to create the pie chart. I then use the second script to...
  10. andyfresh

    if statement with wildcards

    Hi, I currently have a spreadsheet whereby I would like to use the following code however im unsure on how to create the IF statement. Range("L940").Select If ActiveCell Like "*" And ActiveCell.Offset(0, 1).Range("A1").Value And " " And "*" Then MsgBox ("correct") Else MsgBox ("incorrect")...
  11. andyfresh

    Find and replace all but numeric

    Hi, Is it possible to delete everything from a coloumn that isnt numeric?? Regards Andy
  12. andyfresh

    search and replace a string within a string

    Hi, Is it possible to search for a string within all cells from a column and then delete that part of the sting in sql analyzer?? Regards Andy
  13. andyfresh

    Creating a Case Statement to generate a value

    Hi This should be a simple one for those of you who know sql as im quite new to it. Basically I need a value after InvoiceContents.QuantityDispatched AS Quantity and that value depends on the case statements. After that value has been determined I would like it then to carry on selecting the...
  14. andyfresh

    Display data across two lines instead of one

    Hi, Im currently working on a simple collect data from SQL and display, however im having problems with displaying the data. As you can see by the script it returns the data and displays it along one line in a table. Is there any way of returning the data and spreading it over two lines, so...
  15. andyfresh

    asp.net Graph using sql data

    Hi Im currently creating a graph and the two files that I am using are graph.aspx and graph.ascx as shown below. Currently I am using arrays to state the size and names of the bars however I would like this information to be gained from an sql query. The query is: SELECT...
  16. andyfresh

    update sql with a figure gained from a sum

    Hi, This sql is placed within an asp page however im having trouble with the sql itsself. Basically I would like to divide the newsell by the base and then subtract 1 and multiple by 100. The code so far? SQL = "UPDATE Temp_lwlees SET MarkupRate =(" & Request("newsell") & "/" &...
  17. andyfresh

    Date function

    Hi Happy new year to you all, I cam back after the xmas break to find that one of my date functions isnt working and im unsure why. This is the code as it is in query Analyzer: select (convert(char(4),year(getdate())) + '-' + cast(replace(str(Month(DATEADD(DAY,-6,getdate())),2),' ','0') as...
  18. andyfresh

    Disable the close button on a frame

    Hi Im currently creating a site whereby I need people to logout of the site correctly instead of just hitting the cross in the top right hand cornor. Does anyone know a way of how I can disable the close button function on a windows frame?? Regards Andy
  19. andyfresh

    Delivery schedules - creating all possibilities

    Hi all, Im currently creating a delivery schedule in excel where by in row 1 between cell a1 and G1 states the day then underneath I would like them to place a 'y' underneath the day which they would like the delivery to be made. They can have between 1 and 7 deliveries a week. So based on this...
  20. andyfresh

    Outlook predictive addresses

    Hi, Im working in outlook and importing a large address book containing all our clients email details. What I would like to be able to do is when a an employee starts a new message and goes to enter the email address they wish to send too instead of it just bringing up a list of the addresses...

Part and Inventory Search

Back
Top