Search results for query: *

<?php $results = @mysql_query("Select images.image1 from images where images.adid = '$in_Num'"); $ads = mysql_fetch_array($results); $out_Image = $ads['image']; header("Content-type: image/jpeg"); echo "<img src=\"$out_Image\" width=\"360\" height=\"285\">"; ?>

Hi, I'm trying to echo an Image (jpg) type - Longblob from a table and it outputs all funny characters. Example : {sí]  (¢€úÑÒ–Š(¢ŠJ(¢€ (¢€ (¢€ (¢€ (¢€“½:›Ži0ºtϵ?)M7·4€q¨ØæžsMn”
JþšÝ÷vÍy¦¡µn$MzuóbÒBx⼺ôæy äÓBe95Î1ŸÆ¤n¦£4ÄzÏü#š'ý
ôÿüOð¤o and this is only a small section ! I...

Select CUR_TRN_DT, sum(F_LT_AMOUNT), sum(F_LT_AMOUNT) over (order by CUR_TRN_DT) FROM FAT_BSE_LEDGER_TRANS where LT_LEDGER_TYPE_ID='AA' and CUR_TRN_DT>= '01/01/2007' and GL_OBJ_ACCOUNT_DESC='22895' group by CUR_TRN_DT I'm trying to do a runningsum but when I run the code it's failing with...

Juliane26, Could you paste the code please .....

Thanks Greg .... but it didn't seem to work !!

Hi, Does anyone know how to include column names when exporting to a file ..... EG EXPORT TO "C:\NOW.XLS" OF WSF MODIFIED BY 1 METHOD N (WO_DOCUMENT_NUMBER_ID) MESSAGES "X" SELECT WO_DOCUMENT_NUMBER_ID FROM E6DW_DATA.PBVIEWS_SNAP_WORK_ORDERS ; or EXPORT TO "c:\now.csv" of del MESSAGES "X"...

I understand but it does not overwrite the orignal text in the textbox.

Sorry, If this question is ridiously easy ... ' If I click on a button (event) then I can change my textbox value Private Sub btnClosePort_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnClosePort.Click txtSend.Text = "Text value Changed" End Sub 'But how...

Hi, I can read my COMport but I can't seem to display the data in a text box in my WebForm. 'DECLARING Imports MSCommLib " " " " Protected WithEvents mscomm As New MSCommClass() 'OPEN PORT - WORKS Private Sub btnOpen_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles...

Hi Greg, I was just looking at the syntax for the Import command and as far as I can see you can only Import from a file. My current code, Insert into TblA Select .. ... from TblB (a couple of joins etc..) Commit; Thanks

Hello, I have a table (TblA) with 30m records. I want to do an Insert into (TblB) that will commit every 100k records at a time....is this possible? Thanks

Hello, I trying to join 2 tables, I know in some programs SQL the Transform/Pivot works but I'm no too sure how to do it in DB2, any help is appreciated. Table1 LID Lot Date 1 100 01012004 Table2 PID LID Job Value 1 1 JobA 1.5 2 1 JobB 3.5 3 1...

Hi, I have a button on form1 that when you click it it opens form2. Because there are so many controls on there it takes a while to open. Hence I want to have a progress bar on form1 or either on form2. Is it possible to have a progress bar on form1 so when it hits the max.value it opens...

Hi, I have some code, Sub Dim Parentform as Form, Childform as Form Set Parentform = Me.Parent Set Childform = Forms!sfrmChild If Parentform = Childform .. .. EndSub Getting error stating that Forms!sfrmChild is not found and Parentform = Childform (type mismatch). is there something...

Hi, I have some code, Sub Dim Parentform as Form, Childform as Form Set Parentform = Me.Parent Set Childform = Forms!sfrmChild If Parentform = Childform .. .. EndSub Getting error stating that Forms!sfrmChild is not found and Parentform = Childform (type mismatch). is there something...

Thanks Tony, I will give it a go tomorrow at work, what about the page breaks between each subreport that are already set in the report design. Wont they still be set ?

I have the following code ... SUB DETAIL_FORMAT if isnull(me![txtImagePath]) then me![iImage].picture = &quot;&quot; else me![iImage].picture = me![txtImagePath] END SUB this works fine (image is displayed) where the fieldname iImage has a path pointing to an image but when the field is...

Hi, I have a listbox(multiselect) on a form with a valuelist of 4 items (SRep1, SRep2, SRep3, SRep4) each one repersents a subreport. Depending on what items you select I want to show only thoes subreports on the main report. Also, there is a pagebreak between each subreport. (Is it posibble...

Hi, I have a listbox(multiselect) on a form with a valuelist of 4 items (SRep1, SRep2, SRep3, SRep4) each one repersents a subreport. Depending on what items you select I want to show only thoes subreports on the main report. Also, there is a pagebreak between each subreport. (Is it posibble...

Hi, I know in VBA there is a type variant but what would i declare the field type in table design. thanks