Using <BR> inside a quote

Discussions and Tech Support specific to the iMacros Firefox add-on.
Forum rules
iMacros EOL - Attention!

The renewal maintenance has officially ended for Progress iMacros effective November 20, 2023 and all versions of iMacros are now considered EOL (End-of-Life). The iMacros products will no longer be supported by Progress (aside from customer license issues), and these forums will also no longer be moderated from the Progress side.

Thank you again for your business and support.

Sincerely,
The Progress Team

Before asking a question or reporting an issue:
1. Please review the list of FAQ's.
2. Use the search box (at the top of each forum page) to see if a similar problem or question has already been addressed.
3. Try searching the iMacros Wiki - it contains the complete iMacros reference as well as plenty of samples and tutorials.
4. We can respond much faster to your posts if you include the following information: CLICK HERE FOR IMPORTANT INFORMATION TO INCLUDE IN YOUR POST
Post Reply
Prom3th3an
Posts: 4
Joined: Wed Jan 07, 2009 9:45 am

Using <BR> inside a quote

Post by Prom3th3an » Wed Jan 07, 2009 10:47 am

Hi, Im making a script so that I can rename people of my multi database wiki farm. It uses phpmyadmin to do this. MY script so far is below.

Code: Select all

VERSION BUILD=6111213 RECORDER=FX
TAB T=1
SET !DATASOURCE wiki_list.csv
SET !DATASOURCE_COLUMNS 1
SET !DATASOURCE_LINE {{!LOOP}}
PROMPT Please<SP>enter<SP>current<SP>username !VAR1
PROMPT Please<SP>enter<SP>desired<SP>username !VAR2
SET !ENCRYPTION NO
ONLOGIN USER=(BLANKED) PASSWORD=(BLANKED)
URL GOTO=(BLANKED)
FRAME F=2
TAG POS=1 TYPE=A ATTR=TXT:SQL
TAG POS=1 TYPE=TEXTAREA FORM=NAME:sqlform ATTR=ID:sqlquery CONTENT= "UPDATE `{{!COL1}}_wiki`.`revision` SET `rev_user_text` = '{{!VAR2}}' WHERE `revision`.`rev_user_text` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`recentchanges` SET `rc_user_text` = '{{!VAR2}}' WHERE `recentchanges`.`rc_user_text` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`cu_changes` SET `cuc_user_text` = '{{!VAR2}}' WHERE `cu_changes`.`cuc_user_text` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`cu_log` SET `cul_user_text` = '{{!VAR2}}' WHERE `cu_log`.`cul_user_text` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`archive` SET `ar_user_text` = '{{!VAR2}}' WHERE `archive`.`ar_user_text` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`editings` SET `editings_user` = '{{!VAR2}}' WHERE `editings`.`editings_user` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`filearchive` SET `fa_user_text` = '{{!VAR2}}' WHERE `filearchive`.`fa_user_text` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`global_block_whitelist` SET `gbw_by_text` = '{{!VAR2}}'  WHERE `global_block_whitelist`.`gbw_by_text` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`hidden` SET `hidden_user_text` = '{{!VAR2}}' WHERE `hidden`.`hidden_user_text` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`hidden` SET `hidden_by_user` = '{{!VAR2}}' WHERE `hidden`.`hidden_by_user` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`image` SET `img_user_text` = '{{!VAR2}}' WHERE `image`.`img_user_text` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`ipblocks` SET `ipb_by_user` = '{{!VAR2}}' WHERE `ipblocks`.`ipb_by_user` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`logging` SET `log_title` = '{{!VAR2}}' WHERE `logging`.`log_title` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`oldimage` SET `oi_user_text` = '{{!VAR2}}' WHERE `oldimage`.`oi_user_text` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`online` SET `username` = '{{!VAR2}}' WHERE `online`.`username` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`page_restrictions` SET `pr_user` = '{{!VAR2}}' WHERE `page_restrictions`.`pr_user` = '{{!VAR1}}' ;"
TAG POS=1 TYPE=INPUT:SUBMIT FORM=ID:sqlqueryform ATTR=NAME:SQL&&VALUE:Go
Im using the <BR> statement so that every SQL Query is on a new line, but because the whole input for that field is in " " because the iMacro will crash without them the <br> does not get substituted with a new line, thus screwing up the querys.

How can i fix this?
dharmendra2000
Posts: 214
Joined: Fri Jul 04, 2008 1:28 pm
Location: Ahmedabad
Contact:

Re: Using <BR> inside a quote

Post by dharmendra2000 » Fri Jan 09, 2009 4:42 am

Is it not possible to execute each statement one by one, instead of all together?
You can do it using LOOP command! :)
Post Reply