select order_number, line_number, isnull(max(case when linenum=1 then name else null end),”) name1 , isnull(max(case when linenum=1 then value else null end),”) value1, isnull(max(case when linenum=2 then name else null end),”) name2, isnull(max(case when linenum=2 then value else null end),”) value2, isnull(max(case when linenum=3 then name else null end),”) name3, isnull(max(case when linenum=3 then value else … Read more
You could install Oracle XE. It runs much leaner than a full database install, which is what you have with your Developer Day VirtualBox VM. And yes, you can connect to MySQL – assuming you have the MySQL JDBC Jars and an actual MySQL Database to play with. solved What are different ways to create … Read more
You may be simply missing a space between the .php file and the parameter. With your code, the invocation command line would look like this; php C:/xampp/htdocs/sample/sms_send.phpsomething I doubt you have a file with that name. Add a space after .php and see what happens: lclcmd := CONCAT(‘php C:/xampp/htdocs/sample/sms_send.php ‘,’something’); Do post the error messages … Read more