Vim Tips Wiki
No edit summary
No edit summary
Line 6: Line 6:
 
Have one request, would be great if variable can be use instead of parameters prompting, ie:
 
Have one request, would be great if variable can be use instead of parameters prompting, ie:
   
# set opt1 = "somevalue"; opt2 = "somevalue2"
+
// set opt1 = "somevalue"; opt2 = "somevalue2"
# set opt1 = "othervalueset"; opt2 = "othervalueset2"
+
// set opt1 = "othervalueset"; opt2 = "othervalueset2"
   
SELECT * from imaginarytable
+
SELECT * from imaginarytable
 
WHERE field1 = :opt1 AND field2 = :opt2;
 
WHERE field1 = :opt1 AND field2 = :opt2;
   

Revision as of 16:23, 27 October 2011

Use this page to discuss script 356 356

  • Add constructive comments, bug reports, or discuss improvements (see the guideline).
  • Do not document the script here (the author should do that on vim.org).
  • This page may be out of date: check the script's vim.org page above, and its release notes.


Thanks for this great plugins, use it almost everyday.

Have one request, would be great if variable can be use instead of parameters prompting, ie:

// set opt1 = "somevalue"; opt2 = "somevalue2" // set opt1 = "othervalueset"; opt2 = "othervalueset2"

   SELECT * from imaginarytable 
   WHERE field1 = :opt1 AND field2 = :opt2;


So one can select different value before executing above query.

Thanks for great plugin. JK