Recent content by Deeba

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

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

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

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

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

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

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

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=...

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

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

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

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

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

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~

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