|
|
Joined: Aug 2006
Posts: 583
old hand
|
|
old hand
Joined: Aug 2006
Posts: 583 |
When I save a database query in the Database tools, then try to click the execute link to execute that query, nothing happens. I have to cut and past the query into the query window, then click the execute button and that does work, But the execute link for a saved query doesn't work at all for me.
|
|
|
|
|
Joined: Dec 2003
Posts: 6,630 Likes: 85
|
|
Joined: Dec 2003
Posts: 6,630 Likes: 85 |
Basil must be bored and testing a lot of items. Go Basil!!
I tried this myself for the first time and it does not work either except for delete using 7.5.
But I do have a question on the options on saved queries.
There is use,execute and delete.
What is the difference between use and execute?
Blue Man Group
There is no such thing as stupid questions. Just stupid answers
|
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
Use should load it into the textarea for possible edit..
Execute does a load into the textarea and simulates (javascript) hitting the 'Execute' button right after that..
I put that code in for 7.3 and dunno why it might have changed. :shrug:
I think there was some modification to just cleanup the <br /> stuff in the actual text, but nothing more...
i'm curious as to which browser y'all are usin.. i use FFox 3
|
|
|
|
|
Joined: Dec 2003
Posts: 6,630 Likes: 85
|
|
Joined: Dec 2003
Posts: 6,630 Likes: 85 |
Okay. When it works I guess.
Thanks guy.
Right now nothing happens at all.
Blue Man Group
There is no such thing as stupid questions. Just stupid answers
|
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
yep.. it was working in 7.4.1 from my test.. now broken in 7.5 tested with FF3, IE7, Chrome  /templates/default/admin/database.tmpl document.sql.command.value = commandArray[i].replace(/JSLBR/g,'\n');
in an effort to solve the <br> issue, it got broke..
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Hmm, will look and see what I may have borken.
|
|
|
|
|
Joined: Jul 2006
Posts: 4,057
|
|
Joined: Jul 2006
Posts: 4,057 |
Hmm, will look and see what I may have borken. I Love Ricks Honesty 
BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
|
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
and his schpeeling too 
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Found it. Line 39 of templates/default/admin/database.tmpl currently has this:
document.sql.command.value = commandArray[i].replace(/JSLBR/g,'\n');
That, should be this:
document.sql.command.value = commandArray[i].replace(/JSLBR/g,'\\n');
Last edited by Rick; 03/09/2009 1:54 PM.
|
|
|
|
|
Joined: Aug 2006
Posts: 583
old hand
|
|
old hand
Joined: Aug 2006
Posts: 583 |
Looks like it's juat an extra \ needed, right?
|
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
correct.. the \ is a special char and needs to be escaped by using another \ 
|
|
|
|
1 members (Ruben),
1,776
guests, and
98
robots. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
|
