No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Humble and focused
52 Posted Topics
 | ## Stored Procedure ## -- Procedure name: billing_to_invoice_update BEGIN UPDATE accounts.0_debtor_trans SET ov_amount=ov_amount+fee-oldfee WHERE trans_no=encounter AND branch_code=pid; UPDATE accounts.0_debtor_trans_details SET unit_price=fee/units,quantity=units,qty_done=units WHERE debtor_trans_no=encounter AND stock_id=CONCAT(code_type,'/',code); -- gl updates UPDATE accounts.0_gl_trans SET amount=ROUND((-1)*fee) WHERE account=code_type AND memo_=CONCAT(code_type,'/',code) AND last_service_encounter=encounter; UPDATE accounts.0_gl_trans SET amount=ROUND(fee) WHERE account=1100 AND memo_=CONCAT(code_type,'/',code) AND last_service_encounter=encounter; END BEGIN …  |
| | CASE WHEN ((SELECT COUNT(id) FROM users) > 0) THEN BEGIN INSERT INTO users(username,password) VALUES('Moshe','Ahuva'); END ELSE BEGIN INSERT INTO users(username,password) VALUES('Zvi','Idan'); END END My aim is to save with a condition. but it fails and says: "Check the manual that correponds to the right syntax near ELSE BEGIN ....". please …  |
| | SELECT code_type,code,encounter,pid,provider_id,date,CONCAT('code_tye',':','code') INTO @code_type,@code,@encounter,@pid,@povider_id,@date,@standard_code FROM billing FOR EACH ROW BEGIN SELECT procedure_type_id INTO @type_id FROM procedure_type WHERE standard_code='@standard_code' FOR EACH ROW BEGIN INSERT INTO procedure_order(procedure_type_id,date_ordered,provider_id,date_collected,order_priority,order_status ,patient_instructions,patient_id,encounter_id) VALUES('@type_id','@date','@provider_id','@date','high','pending','complaints','@pid','@encounter') END END #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for … |
| | $res=mysql_query("SELECT code_type,code,date,provider_id FROM billing WHERE encounter='$encounter' AND pid='$pid'"); while($row=mysql_fetch_array($res)){ $code_type=$row['code_type']; $code=$row['code']; $date=$row['date']; $provider=$row['provider_id']; $standard_code=$code_type.":".$code; $res1=mysql_query("SELECT procedure_type_id FROM procedure_type WHERE standard_code='$standard_code'"); while($row1=mysql_fetch_array($res1)){ $procedure_type_id=$row1['procedure_type_id']; mysql_query("INSERT INTO procedure_order(procedure_type_id,date_ordered,provider_id,date_collected,order_priority,order_status ,patient_instructions,patient_id,encounter_id) VALUES('$procedure_type_id','$date','$provider','$date','high','pending','$complaints','$pid','$encounter_id')") or die(mysql_error()); } } The above query saves(inserts) more than once in the database. what can be the cause especially in the while …  |
| | function addUsers($params) { $fnameval = $params->getParam(0); $fname = $fnameval->scalarval(); $mnameval = $params->getParam(1); $mname = $mnameval->scalarval(); $lnameval = $params->getParam(2); $lname = $lnameval->scalarval(); if(mysql_query("INSERT INTO users(fname,mname,lname) VALUES('$fname','$mname','$lname')")){ $mess="data and synced successfully";} else{ $mess="data saved but not synced as required";} $response = array('response' => new xmlrpcval($mess, 'string')); return new xmlrpcresp(new xmlrpcval($response, 'struct')); } … |
| | I have data that is inserted into a table A. I want that before 'insert' to table A, I should capture Specific data from the array and insert it into table B. Can somebody show me how to do that ?  |
| | update drugs,drug_sales SET drugs.b_price=(SUM(drug_sales.fee)/SUM(drug_sales.quantity)) WHERE drugs.drug_id=drug_sales.drug_id AND drug_sales.pid=0 update drugs,drug_sales SET drugs.b_price=SUM(drug_sales.fee)/SUM(drug_sales.quantity) in drugs.drug_id=drug_sales.drug_id AND drug_sales.pid=0 The intention of the above 2 queries is to update a table called drugs based on computational results of table called drug_sales. The two queries fails and the error is: "#1111 - Invalid use … |
| | I have a list of columns of table that holds boolean values. consider a,b,c,d,e,f,g,h as column names with **YES** or **NO** values. I want to query and list column names whose value is YES. can some write a mysql query that can list the columns. if a column has an … |
| | $query = "SELECT encounter,amount1,amount2,posted1,posted2 FROM payments WHERE pid='$patient_id'"; $res = mysql_query($query); $max =25; $num_rows=mysql_num_rows($res); $x_count=0; while($row=sqlFetchArray($res)){ $encounter_id=$row['encounter']; //$method=$row['method']; $amount1=floatval($row['amount1']); $amount2=floatval($row['amount2']); $posted1=floatval($row['posted1']); $posted2=floatval($row['posted2']); $total_amount_paid=floatval($amount1+$amount2+$posted1+$posted2); for($x_count=0;$x_count<$num_rows;$x_count++){ //$encounter_id[$x_count]=$encounter_id; $query = "SELECT date,SUM(fee) AS totalcharges FROM billing WHERE pid='$patient_id' AND encounter=$encounter_id"; $res = mysql_query($query); while($row=sqlFetchArray($res)){ $date_fee=$row['date']; $total_charges=floatval($row['totalcharges']); $balance=floatval($total_charges-$total_amount_paid); $pdf->SetFillColor(254,254,254); $pdf->Ln(); $pdf->SetX(10); $pdf->Cell(50,4,$date_fee,1,0,'L',1); $pdf->Cell(40,4,$encounter_id,1,0,'L',1); $pdf->Cell(40,4,$total_charges,1,0,'L',1); … |
| | <?php echo "<center><a href='report.php?date_range=$date_range&patient_id=$patient_id&proce_name=$proc_name> <img src='pdf.jpg' alt='Print Lab Resutl' width='32' height='32'>Print Report</a><center> </p></center>";?> I want to submit some the above parameters to the server side script for processing. However, I do dont receive the sent parameters on the server script. can somebody identify and rectify where the error is .I …  |
| | I am looking for a universal system that can replicate/Synronize database schemas and changed data for mysql,sql server,Oracle or atleast mysql and postgresql. Our company has different branches each with its own local data but any changes in a local database is supposed to be replicated to the central database. … |
| | First time click:  Second Round Mouse click:  The above images shows screen short of a popup that is shown by clicking on a link from a html table i created using Jquery DataTables plugin and data from mysql database. in essense, when i click the linkable … |
| | Consider the following code: while($row=mysql_fetch_assoc($result)){ echo '<tr> '; echo '<td><a href="#?id='.$row['id'].'" class="dep_link"><img src="images/icn_edit.png" title="Edit"></a> <a href="#"><img src="images/icn_trash.png" title="Trash"></a></td>'; In my php form, i have created a jquery dialog link such that when the user clicks the 'icn_edit.png' image , a new iframe is loaded with fields for update. i want to … |
| | <?php require_once('mail.inc.php'); $con = mysql_connect("localhost","root","12345"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("billtest",$con); $today=strtotime(date("Y-m-d")); $query1="SELECT * FROM ab_transactions_paypal WHERE status=0 AND expiry_date>$today"; $result=mysql_query($query1); if(mysql_num_rows($result)>0){ $count=mysql_num_rows($result); for($j=0;$j<$count;$j++){ $row=mysql_fetch_array($result); $token_id=$row['token_id']; $account_id=$row['account_id']; $sku=$row["sku"]; $inv_id=$row['invoice_id']; $bill_amt=$row['amount']; $cust_email=$row['cust_email']; $url="https://ssl.3gsecure.net/api/payment/checktoken.asp?TransactionToken=$token_id"; $httpRequest_OBJ = new httpRequest($url, HTTP_METH_POST); $result = $httpRequest_OBJ->send(); $mine=$httpRequest_OBJ->getResponseBody(); echo $httpRequest_OBJ->getResponseBody(); $s = … |
| | I want to iterate through html table and display the values. for instance, column keys are fname,lname,mkt,positions. if for instance there are 10 rows,how can i access them and send them to php script ?  |
| | function name_loop(){ var names_array = []; $('.name_class').each(function(index){ names_array[index] = $.trim($(this).val()); }); return names_array; } the problem with the above code is that it returns only the first element and not the specified array. can someone solve it for me  |
| | consider code below: //Consider the php part(process.php) <table border="1"> <thead> <tr> <th>Name</th> <th>Language</th> </tr> </thead> <tbody> <?php foreach($_POST['names'] as $k=>$v){ ?> <tr> <td><?php echo $v; ?></td> <td><?php echo $_POST['languages'][$k]; ?></td> </tr> <?php } ?> </tbody> </table> //html part**``** <HTML> <HEAD> <TITLE> Add/Remove dynamic rows in HTML table </TITLE> <script type="text/javascript" …  |
| | i have the following query: 1.$query="SELECT * FROM ab_service WHERE account_id=$account_id AND sku='".$sku."'"; 2.$query="SELECT * FROM ab_service WHERE account_id=$account_id AND sku='$sku'"; none of the above seems to work.the problem is with $sku var because when i dont put it as the condition, i get results.what is the problem ? the … |
| | how can i submit form values to server without refreshing page i.e using ajax.consider fname,lnm,gnd,dpk as sample form fields to illustrate this. |
| | I am trying to process an array to get variable name and its value. below is the code. $s = explode("&",$mine); foreach($s as $k=>$v){ $v=explode("=",$v); for($i=0;$i<count($v);$i++){ $a[$v[$i]]=$v[$i+1]; } print_r($a); } The prolem is that the array repeats itself in output. as shown(look at it keenly): Array ( [APIresult] => 000;APIresultexplnation … |
| | i have created a php application where am using a barcode scanner to load item name and prices from database. the problem is that once the barcode reader finishes reading the barcode, the details are loaded and it tabs to the next field. this means that the user has to …  |
| | i have created a php application where am using **a barcode scanner to load item name and prices from database**. the problem is that **once the barcode reader finishes reading the barcode, the details are loaded and it tabs to the next field. this means that the user has to …  |
| | hi you all, I am creating an application which requres generation of random keys cosisting of 4 numbers(0-9). However, i realized that at some point,the random numbers repeats themselves. how can i avoid this repetition.the numbers form the primary key of a column in sql database table.  |
| | i can create an asp.net application but i don't know how to compile it to run. can somebody help me on how to make it run because at the moment, it runs on visual studio alone. how can i make it run in an environment without vb.net IDE?  |
| | Hi brothers,i am creating an application that i want to load a pre-designed crystal report from database records and print it in pdf format and send it as e-mail attachment. I know how to send it as an attachment but i don't know how to print it in pdf automatically … |
| | i am creating an invoice creation project where every client has a certain date for payment per month. how do i put the system to update next payment date e.g if client x is supposed to pay on 6th every month and has paid for april,the system should automatically update … |
| | i have developed a system which needs to process funds transfer using means of mobile phone sms(short message sent). my problem is that i don't know how to intergrate the application with the sms gateway. suppose sms has been sent through the gateway,what will trigger the system to respond since … |
| | use tcp/ip protocals to connect to the remote machine. first configure sql to accept remote tcp/ip connections |
| | I have developed a system which should be accessed remotely. the system reads sql credentials from a notepad file to authenticate to the remote sql server. however, when trying to connect, the system says: "request for odbc permission failed". but if i put the application on the client machine together … |
| | I have developed a system which should be accessed remotely. the system reads sql credentials from a notepad file to authenticate to the remote sql server. however, when trying to connect, the system says: "request for odbc permission failed". but if i put the application on the client machine together … |
| | i have written an application in vb.net 2008 that i want to access a remote database. when it tries to connect, this is the error message: system.data.odbc,system.data,version=2.0.0,culture=neutral,publicToken=b77a5c561934e089 failed what might be the problem? thanks  |
| | i hav created an application using odbc as data source. the connection to the database uses the following code: dim myconnection as new odbc.odbcConnection("server=192.168.100.84";dsn=cleaners) myconnection.open .. .. the above code does well when i change the ip address to 127.0.0.1 i.e to localhost.but when i use it on a computer …  |
| | i am creating a client server application using vb.net with odbc as my data source to sql server 2005. send me a code that will enable the application running on a client machine to connect to a remote server.the application is to run on LAN and other client machines are … |
| | I have created an application using ODBC data sources.it runs on a local machine well. but i want it to run on client machines from central server.the following is the code that i use: dim myconnection as new odbc.odbcConnection("dsn=cleaners") myconnection.open where cleaners is a data source i have manually created … |
| | am developing an application using vb.net 2005.i want the application top read what has been recorded by an electronic balance and display it on a textbox. communication between the balance and the computer/PDA is through a bluetooth. can somebody help please?  |
| | This are the steps of creating a crystal report >project-add new item-standard style-select data source for your data-- follow the wizard. >drop a crystalreportviewer on your form. set its docking propert to fill. >>>>>actual coding here<<<<< dim report as new crystalreport1.rdc reportviewer1.reportsource=report crystalreportviewer1.refresh NB:report is a variable.you can call yours … |
| | i have downloaded Ireport and Jasper Report softwares. i hav created a system using netbeans installed in linux. Unfortunately, i dont know how to install ireport so that i can use it to generate reports. can somebody help me?  |
| | Am using a crystal reportviewer to generate my reports. Every time the report is loaded, the 'Main report' header is displayed;but, i don't want it displayed because it does not look smart.Can somebody help me remove it? |
| | it depends on the server that u're using but mostly, we use sybase(sql everywhere) which has the ability to directly link and synchronize a PDA application.windows server 2008 has windows mobile but for windows 2003, you have to install microsoft active sync. it is free for download.Also, if the link … |
| | I have developed a system which i want my client to use for trial purpose for 1 month. i want a software or an idea to time the system for that period after which it should cease to work. can somebody help me? |
| | 1.'assume that the 'admins' or any user is populated in a combobox aor any suitable control the it is as follows Private Sub MRMMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 2. 3. If Me.selectedItem = "Meeting Room Manager - ADMIN" Then 4. btnNewUsers.Enabled = True 5. btnCurrentBookings.Enabled … |
| | hav developed an application using vb.net 2005. i want to create an asp.net form which if i click a button on the asp.net form, i launch the login form for the vb.net application. i dont have any idea. please help. |
| | i have installed mplayer in SUSE linux enterprise server 11. but it does not play video in the foreground.while it is playing(producing sound only), i cant do other tasks and it hung till i have to forcibly shutdown the computer. i think it needs some libraries in order to play … |
| | am new to c++. i want to create a desktop application but i don't know how to create a user interface-forms like vb.ne forms using dev c++ IDE. how do i go about it.  |
| | i have a table in my database that stores store items and their respective prices. i need a code which will, after displaying the items on listview,give the sum of their cost. i.e, when you use listvie1.items.count only gives you the count of the columns. i want to capture the … |
| | my crystal report displays group tree. though it is important for navigation, i want to get rid of it whenever the report loads-just plain report.can somebody help me? |
| | Am developing a software project using vb.net 2005. I have created an external file which is the program's help file. Can somebody help me with a code that can load/invoke it to be useful to the user? the help file is .CHM  |
| | am developing an inventory management system. have two listview controls. one for ITEM and another for details pertaining date, quantity, cost, issued to and so on. i want a vb.net code that if a given item in listview A is clicked, listview B details are cleared and then the details …  |
| | my reportviewer displays message "Report Being generated". i want to change it to names like "Please......wait".how do i go about it ? |
| | have been creating reports using crystal report and crystal report viewer. but i want now to generate them from sql databse using reportviewer. my report does not display any record. for a crystal report, to load data, the code is for example: dim myreport as new crystalreport1 crystalreportviewer1.reportsource=myreport crystalreportviewer1.refresh and … |
The End.