107 Discussion / Question Topics
Remove Filter  | [code=php] while($row = mysql_fetch_assoc($resultParam_pp)) { $lblParameter_pp = $row['ParameterName']; $lblParameterSeq_pp = $row['Parameter_seq']; echo "<tr>"; echo "<form action = 'http://10.237.102.158/SPC_Stations/Grinding/spc_grd_02.php' method = 'post'>"; echo "<td align = left>"; echo "<input type = 'radio' name = 'paramSelect' value = '$lblParameter_pp' checked><font face = Arial size = 2>" . $lblParameter_pp; echo "<input type = … |
| | Hi! I've found this code in the net that merges rows successfully. However, the data is being written in the last row of the merge rows. What I want is that it should be written on the first instead. This is the code: Using gridBrush As Brush = New SolidBrush(Me.dgSM.GridColor), … |
| | i want to combine multiple rows into a single row using **DB2**. I have found this code, but I do not know how can i edit it>? CREATE FUNCTION MySchema/MyUDF ( PARCol2 CHAR(5) ) RETURNS VARCHAR(1024) LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA CALLED ON NULL INPUT DISALLOW PARALLEL BEGIN …  |
| | Hi Guys! This code is working fine before I removed other programs from my computer since it is already getting slow. Now, i don't know which program I've deleted that I needed to restore again. Error Code Says: `The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.` I am … |
| | Hi! I have two tables. Table 1 - fields are: no, referenceno, date, marine Table 2 - fields are: no, referenceno, controlno, date What I would like to do is to retrieve the field **controlno** from table 2 when field **marine** in table 1 = "Y". Coding: SELECT NO, REFERENCENO, … |
| | hi guys.. i always got this error in vb6.. here's my code [CODE] '########### Variable declaration ########### Dim conn As ADODB.Connection Dim rs As ADODB.Recordset '########### Variable initialization ########### Set conn = New ADODB.Connection Set rs = New ADODB.Recordset strUserName = txtUserName.Text strPassWord = txtPassWord.Text connStringSQL = "MySQL ODBC 5.1 … |
| | hi guys, i just want to ask, how could i get the value of the textbox using the onchange() function. i know that using the form action and method get is one possible solution but what i want is that the value of the textbox in page1 should be passed … |
| | How can I upload the data from an Excel Spreadsheet to my database in DB2? Thanks! :)  |
| | Hi Guys! I'm having problem with uploading the file to the server. This is my code. $path = "Files/01 Admin Procedure/" . basename($_FILES["txtFilename"]["name"]); $x = move_uploaded_file($_FILES['txtFilename']['tmp_name'], $path); //Move file to directory if ($x) { echo "<script>alert('File " . basename( $_FILES["txtFilename"]["name"]) . " has been uploaded!')</script>"; } else { echo "<script>alert('Error … |
| | Hi! I have an bound datagridview in vb.net. I have it pre-formatted the way I want it. Like for example the `.displayIndex` which columns will come first, etc. This works fine when the form is first loaded. But when it is loaded again, the format is being resetted. Sample: - … |
| | Hi! I am doing the programming on my computer and it works fine-the program, the database itself, inserting to the database is also working fine. But when I publish it and install the program on another computer. It crashes and does not execute the `INSERT` command. Here is my code. … |
| | So here's the error in the Event Viewer. Application crashes when inserting data to the database. DAtabase: AS/400 iSeries DB2 Faulting application name: 242-CEWE.exe, version: 1.0.0.0, time stamp: 0x542a2ac6 Faulting module name: MSVCR80.dll, version: 8.0.50727.6195, time stamp: 0x4dcddbf3 Exception code: 0xc000000d Fault offset: 0x00022b5c Faulting process id: 0x12ec Faulting application … |
| | Hi! I want to display a table in the Local Report using SQL Connection. Parameters will be user-defined. Example. sqlSearch = "SELECT * FROM shipment WHERE " & port & " BETWEEN @datePerformedFrom AND @datePerformedTo ORDER BY recno DESC" `@datePerformedFrom` and `@datePerformedTo` will be supplied by the user. Please help … |
| | Hi! The for loop works and it reads the value of `recno()`. However, the sql code itself is being executed once only. Is there any tweak I need to do for DB2 iSeries codes? For k = 0 To recno.Length - 1 sqlUpdate = "UPDATE shipment SET status=@status WHERE recno=@recno" … |
| | Hi! I have this code from the internet but it didn't work well. I want to set the margin of the Report Viewer during runtime. Because I have this form to fill up. Instead of handwriting it. I programmed it. But there are certain positions of the textboxes in which … |
| | Hi! I am using Data Grid View to display the data from my database. This code works properly. It displays the data. This code is inserted in the Form_Load of the form. Dim cmdCount, cmdGet As New iDB2Command Dim daGet As New iDB2DataAdapter Dim dsGet As New DataSet Dim sqlCount, …  |
| | Hi! Could you help me initialize or load the data into a Data Grid View Control using iDB2 Connection? I've tried this code I've seen from the net but it does not seem to work :( I am initializing the connection using form_load and not in the Properties Window. Imports … |
| | Hi! These are the basic things I know about iDB2Commands to be used in Visual Studio 2010. Could you please help me how could I extract data from DB2? I know `INSERT`, `DELETE` and Record Count. But `SELECT` or Extract Data and `UPDATE` I don't know. Imports IBM.Data.DB2 Imports IBM.Data.DB2.iSeries … |
| | Hi! I have no problem when trying to execute and `insert` or a `delete` SQL Command. However, this `update` command does not seems to work well and I am having a hard time to figure it out. Kindly help me please. I am using an i Series or AS/400 database. … |
| | Hi! I already established an iDB2Connection, now what I want to know, is how could I execute SQL Queries for INSERT, DELETE and UPDATE. I had tested the code already and it works. The code for count works; I get the total number of records. My question is that for … |
| | Hi! My database is in AS/400 DB2 hence, I am using SQL. Here's my line of code for opening a connection. Dim str As String = "User ID=EDITH;Password=EDITH;Data Source=10.0.1.11;Initial Catalog=ictms;Integrated Security=True" Dim conn As SqlConnection = New SqlConnection(str) conn.Open() Now, I wanted to execute a delete query, however, I already … |
| | Hi! This is my Gridview1 and I wanted to get the value of the recid column using the GridView1_RowEditing method <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" DataKeyNames="RECID" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True"> <Columns> <asp:CommandField ShowSelectButton="True" /> <asp:BoundField DataField="RECID" HeaderText="RECID" InsertVisible="False" SortExpression="RECID" /> <asp:BoundField DataField="DOCUMENT_NUMBER" HeaderText="DOCUMENT_NUMBER" SortExpression="DOCUMENT_NUMBER" /> </Columns> </asp:GridView> Please help me, I …  |
| | Here's my **formview**.. <asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource1" DataKeyNames="recid"> <EditItemTemplate> RECID: <asp:TextBox ID="recid" runat="server" Text='<%# Eval("RECID") %>' ReadOnly="true" /> <br /> SHIPPER: <asp:TextBox ID="shipper" runat="server" Text='<%# Bind("SHIPPER") %>' /> <br /> <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update" Text="Update" /> <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" /> </EditItemTemplate> </asp:FormView> here's my **sqldatasource1** …  |
| | Hi! This is my code to get the difference of two dates in Javascript. var today = new Date(); var dd = today.getDate(); var mm = today.getMonth()+1; //January is 0! var yyyy = today.getFullYear(); if (dd < 10) { dd='0'+dd } if (mm < 10) { mm='0'+mm } today = … |
| | This is the code for my third level drop down menu. <ul id="menu"> <li><a href="ourlovestory.php">Our Love Story</a></li> <li><a>Notes</a> <ul> <li><a href="blog.php">Blog</a></li> <li><a href="guestbook.php">Guestbook</a></li> <ul> <li><a href="guestbooksign.php">Sign our Guestbook</a></li> </ul> </ul> </li> </ul> What i want is the third level, Sign our Guestbook, be hidden then be displayed once hovered to … |
| | Hi! I've copied this drop down menu code from the web. It's working fine and the submenu's are displaying. However, when I place another div next to the first one. The submenus were hidden already. Could you help me? This is the header file. <div class="divMonogram" onmouseover="this.style.cursor='pointer';" onclick="window.open('index.php', target='_self');" align="left" …  |
| | [U]this is my code in php:[/U] [CODE]<?php echo "Hi!"; ?>[/CODE] [U]this is my code in javascript:[/U] [CODE]alert(xmlhttp.responseText);[/CODE] now, my problem is that the output displays: "1Hi!"; even though i will not display an output in php, still a "1" appends in the beginning of the alert box. What could be … |
| | hi guys, this is the scenario, i have two textboxes, then a submit button. now, when the user clicks the submit button, it will verify if both textboxes have values, otherwise, if only one of them is empty, an alert box will be displayed prompting the user to complete the …  |
| | could you give me a syntax for insert into using db2 as the database and vb6 as it's front end? i am trying to insert a numeric value to my table coming from a host variable in vb6, however, i do not get the proper syntax for it..could you help …  |
| | front end: Visual Basic 6.0 [CODE] Dim intAmount as integer intamount = val(txtamount.text) [/CODE] Back end: AS/400 db2 library: CPALLIB field: amount type: Numeric Len: 9 Decimal: 2 value: 100000 The problem is that when i insert new record to my database for this field: (amount), the value is 100000. …  |
| | hi, how could i change the color of the cell in a table using this code?? [CODE] <script language="javascript"> function addRow(tableID) { var table = document.getElementById(tableID); var rowCount = table.rows.length; var row = table.insertRow(rowCount); var cella = row.insertCell(0); var element1 = document.createElement("input"); element1.type = "text"; element1.name = "txtManufacturer[]"; element1.size = … |
| | hi guys, just want to ask some question. i have two textboxes txt1 and txt2. these two possess jquery autocompletes within.. now, what i want to do is that this two are interconnected. Meaning, the values in autocomplete in txt2 will depend upon the values inputted in txt1. consider this … |
| | hi guys, i have this program wherein the user can add freely how many textboxes he want. now my problem is that i have a class on my first textbox which is [CODE]class= "TextBox"[/CODE] then, i want to add that class name to the textbox added by the user..how could … |
| | hi guys, i already have the code for autocomplete.. what i want is that whenever the user inputs a certain character in the textbox the letters in the autocomplete should be emphasized, let's say, highlighted or bold. see attached example, |
| | hi guys, i already have and can make a autocomplete form using jquery plugin..it works fine..but the problem now is, i want the data to be stored in the database now, and not only in a javascript file..is it possible>? could you help me? here is my code.. [CODE] <script … |
| | hi guys, i am generating a certain element using javascript inside a table.. now, my problem is that, inside a cell, i will input a text and a textbox.. if the sequence is like this, text textbox both displays in the screen, if it's like this, textbox text only the … |
| | hi guys..is there a problem with my code? because, i am trying to add a row dynamically depending on the user requirements, what the code does is that, whenever the image is clicked, only the textbox appears, what should happen is that the textbox should be inside the row.. [CODE] … |
| | hi guys, could you help me? how could i create a dropdown button automatically once a value is inputted in the textbox.. thanks thanks..  |
| | hi guys, i have this page, add_row.html, this page dynamically adds another row of inputs as per the user requirements.. [CODE] <HTML> <HEAD> <TITLE> Add/Remove dynamic rows in HTML table </TITLE> <SCRIPT language="javascript"> function addRow(tableID) { var table = document.getElementById(tableID); var rowCount = table.rows.length; var row = table.insertRow(rowCount); var cell1 … |
| | guys, this code below will dynamically add new rows to the page once the link is clicked..now, my problem is that how can i get the value of the inputted rows.. [CODE] <SCRIPT language="javascript"> function addRow(tableID) { var table = document.getElementById(tableID); var rowCount = table.rows.length; var row = table.insertRow(rowCount); var … |
| | could you help me to make a basic css which is applicable for the autocomplete in php? tnx..^^ |
| | is there any code that is the same as the distinct function of mysql to mssql? thanks in advance..^^ |
| | is it possible, that when a user clicks an image, it will automatically add a row to the table? this is table.. |
| | could you help me guys to translate this code from PHP MySQL to PHP ODBC. i'm having a hard time to run this page using the PHP ODBC which uses MSSQL connection. any help would be very much appreciated.. thanks in advance ^^ [CODE] <?php $return_arr = array(); $sql = … |
| | hello guys, i had a problem with the automatic email sending using php.. the error states: [CODE] Warning: mail() [function.mail]: "sendmail_from" not set in php.ini or custom "From:" header missing in C:\xampp\htdocs\edith\email\index.php on line 36 [/CODE] *******index.php *******this is my code [CODE] $to = "juan@yahoo.com"; $subject = "Email testing"; $message … |
| | could you give me a very simple example of autocomplete in php? this should have a connection to the database.. having the keydown() function and highlights the letters which are similar to the one being typed. best regards and thanks in advance..^^ |
| | how could i add the onkeydown() function in jquery.. this is for the autocomplete.. regards, ^^  |
| | hi guys, could you help me with this one? this is about the autocomplete in php using a textbox.. my problem with this code is that when i used KeyDown on my keyboard, it should automatically input in the textbox the data, but mine is different, it displays "undefined" instead. … |
| | hi guys,.need help.. want to have a simple bar graph in html/php that should display the basic legends, -x and y data -graph title -x and y ranges.. please help..tnx in advance ^^  |
| | plotting data coming from a live database using mysql in a webpage using php/html. thanks in advacne.^^ |
The End.