396 Posted Topics
 | Hi, [code] function openingBalance($accountNum) { $sql_OpenBal = " SELECT closing_balance FROM bank_balance WHERE bank_account.account_no = $accountNum "; [COLOR="Red"]$runSql = mysqli_query($mysqli, $sql_OpenBal);[/COLOR]... [/code] Red line generates an error. "Warning: mysqli_query() expects parameter 1 to be mysqli, null given". I call function [inlinecode]echo openingBalance (1500);[/inlinecode] How can i search $accountNum in SQL … |
| | Hi, Red line below generates error "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource". I have checked sql string too. Thanks [code] <?php ob_start(); $dbhost = "localhost"; $dbuser = "root"; $dbpass= ""; $dbname = "test"; @mysql_connect($dbhost,$dbuser,$dbpass) or die ("No connection."); @mysql_select_db($dbname) or die ("No database!"); $page = …  |
| | Hi, How can add 4 rows and 6 columns into MsFlexGrid1 with Command_click event in VB6? Thanks |
| | Hi, When i click on a datagrid, the selected row's id is added into a text or combo or listbox. User will see and navigate through the added items but, can't change. What is the best way to do this? I need to disable changeable property of text or combo … |
| | Hi, I populate data from database to datagrid but, cursor focuses on last row. How can i make it focused on to first row? Thanks  |
| | Hi, I fill the Dbgrid with information that come from database via adodc connection. Is there any chance to add checkbox across the each records listed in Dbgrid? I will check one or several particular records and update them with a record stored in a textbox. For example; [code] ....UPDATE … |
| | Hi, I have encripted password column in my table. I use VB6 code below to check password but it doesn't work. I think i have to call a function to decrypt it. Where and which function do i use in my sql code below with text1.text. Thanks [code] .......WHERE psw=' … |
| | Hi, I encrypte my data when i insert into database. [code]insert into person (name, psw) values ('john',SHA1('111'));[/code] What about when it comes to checking that particular encripted values? Is there any function to use agains SIH-1. I have a textbox and i wanted to verify it with checking encripted data. … |
| | Hi, Information is being listed from middle of the page, not the begining of the page. Why? Thanks [code] <html> <head></head> <body> <Table border="2px" > <tr> <td>ID</td><td>Name</td><td>Surname</td> </tr> <?php $mysqli = new mysqli("localhost","root","","dbf"); if (mysqli_connect_errno()) { printf ("Connection failed : %s\n", mysqli_connect_error()); exit(); } else { $sql = "SELECT id, … |
| | Hi, I set DataGrid1 column width as follows, but it doesn't effect when i run my program. [code] DataGrid1.Columns(0).Width = 3030.236 DataGrid1.Columns(1).Width = 1604.976 DataGrid1.Columns(2).Width = 1904.882 DataGrid1.Columns(3).Width = 1065.26 [/code] Thanks |
| | Hi, I have a subroutine(callMe) in Module1. I want to call "callMe" in other subroutine in Form1. I cant do it. I cant call subroutine in other subroutine. How do i do it. Thanks  |
| | Hi, Code below retrieves some of the enum values, not all. Why? Thanks [code] Dim RST As New ADODB.RecordSet Combo1.Clear RST.Open "Select Distinct Title From MyTable",Conn If Not RST.EOF Then RST.MoveFirst Do While Not RST.EOF Combo1.AddItem RST(0) & "" RST.MoveNext Loop End If [/code] |
| | Hi, How do i select a particular value of a combobox? Example [code] combo1.selectvalue(rset.field("id"))[/code] I believe you understand what i mean. I bring data from database and want select it in combo. Thanks  |
| | Hi, I have a table in my web page. I want to arrange the margins very close to sides (left, right, above, below). Because, table is wide i cant see some columns when i print it off. How do i do this? Is it with HTML or CSS? If any, …  |
| | Hi, I have solved table margins problem but now, I want to set "Page setup" margins in HTML or CSS. How can we do it? I dont want to set them manually all the time before printing. Thanks  |
| | Hi, I have a table in my web page. I want to arrange the margins very close to sides (left, right, above, below). Because, table is wide i cant see some columns when i print it off. How do i do this? Is it with HTML or CSS? If any, …  |
| | Hi, [code] Create table myTable( title ENUM ('Mr', 'Mrs', 'Miss') NOT NULL DEFAULT 'Mr' ); [/code] How can i load ('Mr', 'Mrs', 'Miss') into a combobox in VB6. Thanks |
| | Hi, I have 2 tables "name1_" and "name_2". I want to compare them. If name in "name_1" table is same as name in "name_2" table, then copy whole row into other table "name_3". Thanks |
| | Hi guys, How can i convert code below into INNER JOIN style. Thanks [code] UPDATE def_1 SET Valid = 'Yes' WHERE id IN (SELECT id FROM def_2) AND paid IN (SELECT paid FROM def_2) AND valid IS NULL [/code] |
| | Hi, I have created a project in VB6. How can make it SETUP / INSTALL kit? I have added some refferences and components as well. Thanks |
| | Hi, [code] INSERT INTO table1 (supid, paid) VALUES ( (SELECT supid FROM def_1 WHERE id IN (SELECT id FROM def_2)), (SELECT paid FROM def_1 WHERE id IN (SELECT id FROM def_2)) [/code] This code returns more than 1 value, teherefore i can not execute it. Is there any other way … |
| | Hi, [code]select id, pay from def_1 where id = (select id from def_2) and pay = (select pay from def_2)[/code] This generates an error "Subquery returns more than 1 rows". Where is mistake? Thanks |
| | Hi, How do went SMS text message to a mobile phone in VB6? Does anyone have any example for it? Thanks  |
| | Hi, How do i go to next paragraph to add additional note? [code]MAPIMessages1.MsgNoteText = "Dear" & " " & Adodc1.Recordset.Fields("cusname") & " " & Adodc1.Recordset.Fields("surname") & ","[/code] Example; Dear www xxx, Next paragraph will start from here. Thanks |
| | Hi, I am trying to install Oracle 9i but when it comes to Java Runtime Environment, it asks me path for it. I have JRE installed in my Computer. What else do i need to proceed this installation? Thanks |
| | Hi, I use VB6 with Oracle database. I also use Adodc and datagrid for retrieving data from database. If i do search with [inlinecode]Select.....Where name IN(LIKE) '" & Text1.text & "'[/inlinecode] does return nothing. I have to type exact value be searched. Why do you think that IN or LIKE … |
| | Hi, [code]Label6.Caption = rcsetFran.Fields("franchiseid")[/code] generates an error"Method item of object Fields failed". If i do [code]Label6.Caption = rcsetFran(0)[/code] then doesn't accept '0', i need to give '1'. In this case i can't return first column in the table. 1 returns second column. How can i solve this problem. Thanks |
| | Hi, How can i call a Oracle Stored procedure in vb6? Stored procedure : [code]ADD_SP (1, '1', 1, 1, 'abc')[/code] Thanks |
| | Hi, I use Oracle database with vb6. [code]Label6.Caption = rcsetFran.Fields(0)[/code] generates 'Type mismatch and Variable uses an Automation type not supported in Visual Basic'. 0 is a autonumber column. Solution is to use 'Use a variable of a type recognized by Visual Basic'. If i do this, i cannot use … |
| | Hi, Is there any way to send a SMS Message in VB6? If so, please share your information with me. Thanks |
| | Hi, What configs i need to do to connect to Oracle 10g? I use wampserver. Thanks |
| | |
| | Hi, What do i need to do to send SMS message or Email via Oracle 10g database? How do we do that? Thanks |
| | This what i do; Can anyone tell me whay i receice an error. 1- Run "SQL Command Line". 2- [inlinecode]connect / as sysdba[/inlinecode]. "No error". 3- [inlinecode]@?/rdbms/admin/utlmail.sql[/inlinecode]. "Created and no error". 4- [inlinecode]@?/rdbms/admin/prvtmail.plb[/inlinecode]. "Created and no error". 5- [inlinecode]GRANT execute ON utl_mail TO SYSTEM;[/inlinecode] "No error" 6- Open my "Oracle … |
| | Hi guys, Both cursor works if i don't use them in one Stored procedure. Both cursors return TRUE for(cursor_x%found). But, insert into process doen't work in cursor_1. Is there any structure problem? Thanks [code] CREATE OR REPLACE PROCEDURE ADD_RENTAL_SP IS -- cursor1 CURSOR cursor_1 IS SELECT ...... rec1 VARCHAR(15); -- … |
| | Hi, Where is the mistake? It doesn't work. thanks [CODE] CREATE OR REPLACE TRIGGER A_ACCOUNT_EKLEME BEFORE INSERT ON A_SIPARIS CURSOR CURSOR_TARIH IS SELECT TARIH FROM A_ACCOUNT where TARIH = SYSDATE; FOR EACH ROW BEGIN IF CURSOR_TARIH%NOTFOUND THEN INSERT INTO A_ACCOUNT (TARIH, PRICE) VALUES (SYSDATE, '1'); END IF; END; [/CODE] |
| | Hi, I need to send a SMS message or/and Email in my database project. Which one is better option for me; Shall i create database with Oracle or MySQL? Thanks  |
| | Hi, I can not use below code in stored proc in oracle; [code] IF (SYSDATE = '04-MAY-08') THEN ... END IF; [/code] This doesn't work either way (true or false). Is there any other way to check it? thanks |
| | Hi, I need a trigger; - to find number 1 from "ID" column and - update "AVAILABILITY" column from Yes to No in "PRODUCT" table. Thanks |
| | Hi, How do we connect to the Oracle with PHP? I can't find codes. for example: database connection name : Hello user name: system password : 123123 hostname : localhost port : 1521 thanks |
| | Hi, 1- When i insert more than 30 datas (at once) into a table, does sequence cache size(20) effect anything because, i use sequence for auto increment in the table. 2-What happens if i increase the cache size from 20 to 50? thanks |
| | Hi, When i insert data into any table last number of sequnce get increased in all sequences that are listed below. These are for auto incremented numbers. All tables have their own autoincremented coloumns. Can anyone see mistake? Thanks [code] CREATE SEQUENCE FRANC_AUTOINC_SEQ START WITH 1 INCREMENT BY 1 NOMAXVALUE; … |
| | Hi, When i click on a link in my html page, it will play xxx.midi. How do we do this? Thanks  |
| | Hi, I have just downloaded 10g express edition but there is no user interface like SQL Server has. Does anyone prefer any program because i am new for Oracle and have never used before. Thanks  |
| | Hi, Below trigger increments double(2,4,6,8...) not single. I want single. Where is mistake? If you can not help, is there other way to do auto increment? Thanks [code] CREATE TABLE MY_TEST ( IDNUM NUMBER, NAME VARCHAR2(4000) ) ; create sequence test_seq start with 1 increment by 1 nomaxvalue; create trigger … |
| | Hi, I have a project which requires me to use PL/SQL blocks, PL/SQL cursors, PL/SQL stored procedures, PL/SQL stored functions and PL/SQL triggers. I think(not sure) i can create PL/SQL stored procedures, PL/SQL stored functions and PL/SQL triggers in MySQL. Can i create PL/SQL blocks and PL/SQL cursors within MySQL … |
The End.