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: Deeba
  • Order by date
  1. Deeba

    How to Schedule a Stored procedure

    Thanks DonQuichote, I'm using a Mac, but the database is running on the Client's ISP, I will check to see which OS it is using. The different MySql account is a good idea. ~Deeba
  2. Deeba

    How to Schedule a Stored procedure

    Hello, I'm just getting back into mySql for a client project, and have a question. I'm using MySql 5.0, with the phpMyAdmin front end. I would like to schedule a simple delete to run every few days on my database. I assume I have to put the Delete into a stored procedure, but were to save...
    • Deeba
    • Thread
    • Replies: 2
    • Forum: MySQL
  3. Deeba

    Reverse numbers in ordered list?

    Thanks for your response. Is there any way to do this without Javascript - ie with CSS and HTML? ~Lori
  4. Deeba

    Reverse numbers in ordered list?

    Hi, I would like to know if it's possible to reverse the order of the numbers in an ordered list, say it starts at 30 and goes down to 1. I would like to do this without coding the value for every <LI> tag, as they could change in the future. Wondering if this could be done with CSS or even...
  5. Deeba

    iframe height=100%

    Hi, Try using quotes around the elements. some browsers are picky. height="100%" Small change but worth a try. ~Dragonfly
  6. Deeba

    Attach file to email?

    I've never used the CDO object, where can i get more info on how it's used? ~Deeba
  7. Deeba

    Attach file to email?

    Hi, I need to know how to attach a file to an email. For example the web page will say &quot;click here to send this page to a friend&quot;. Can anyone set me on the right track? Thanks, ~Deeba
  8. Deeba

    How do you use more than 1 stylesheet for one XML?

    Here is one way it can be done using javascript: function openNewXSL(blah) { var newWindow=window.open('','','toolbars=no, height=175, width=550') var objXml = new ActiveXObject(&quot;Microsoft.XMLDOM&quot;) objXml.async = false objXml.load(&quot;XMLoutput.xml&quot;) var theNode=...
  9. Deeba

    can you query against results set from a stored procedure?

    Or you could save the results from the stored procedure to a temporary table.
  10. Deeba

    Limit on string length returned from a query.

    Often there is a limit to the characters returned in a column. Try using QA and going into tools - options - results(tab) and changing the &quot;Maximum characters per column&quot; to a larger number. The max is 8192 characters. If this doesn't make a difference post your query, or error...
  11. Deeba

    A name was started with an invalid character

    Do you know which line in the script this is pointing to? Maybe with a short snippet of your code we could help. ~Deeba~
  12. Deeba

    Displaying all tables and their fields.....

    sp_tables will return all tables and objects that could be used in a FROM clause. Hope this helps ~Deeba~
  13. Deeba

    Declared variable in SELECT statement

    Hi, This is straight out of SQL BOL: SELECT @local_variable Specifies that the given local variable (created using DECLARE @local_variable) should be set to the specified expression. SELECT @local_variable is usually used to return a single value into the variable. It can return multiple...
  14. Deeba

    Cut-off texts in SQL Server

    Hi, One idea to try out in Query Analysier is to change your result settings. Tools -> Options -> Results and change the maximumn characters per column to a larger number than the preset which is 256. The largest it could be is 8192 i believe. Hope that gives you a lead ~Deeba~
  15. Deeba

    XSL horror

    Are you sure you are in the right Forum? It sounds like you are using HTML and Javascript, I would try there. ~Deeba~
  16. Deeba

    Temp Table size limitation?

    Thanks Terry, I couldn't find that info anywhere. ~Deeba~
  17. Deeba

    Temp Table size limitation?

    Hi, Does SQL Server 7 have any sort of size limitation on it's temporary tables? Thanks :)
  18. Deeba

    How does XSLT really work?

    XSLT processing is limited on IE5. Follow this link to get the list of supported XSLT elements, it isn't a long list. http://www.w3schools.com/xsl/xsl_ie5elementref.asp Good luck!
  19. Deeba

    ***URGENT***writing XML using Javascript - InnerText

    Thanks, I was looking for something like that! ~Deeba
  20. Deeba

    ***URGENT***writing XML using Javascript - InnerText

    Ok I've found the following code. Looks a lot like VBscript. Here's the example: function saveLocalData(theData){ var newObj = new ActiveXObject(&quot;Scripting.FileSystemObject&quot;) var theFile = newObj.CreateTextFile(&quot;c:\\blah.txt&quot;, true) theFile.WriteLine(theData)...

Part and Inventory Search

Back
Top