xuexue

[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" /> &nbsp; <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. …