Hello I had a problem uploading or adding a file on the database and shows the error stated on the title. The column holding the binary data was set to varbinary(MAX). I couldn't find what was my error because I was able to upload a 900kb MS Word Document but it fails on a 51kb file. By the way, here is my table format. fileid int filetype varchar(50) filename varchar(50) filebytes varbinary(MAX) fileext varchar(10) posted datetime uploader varchar(50) I have a filter on each varchar fields so it won't produce an error. Please help. Thanks

Member Avatar
Member Avatar
+0 forum 3

Is it possible to retrieve a text from a URL or page content by using something like ImageUrl property on the Image Control? Ex in image: <asp:Image runat="server" id="Image1" **ImageUrl="getImage.aspx?id=2"** /> Let's say I have this code on getText.aspx Imports System.Data Imports System.Data.SqlClient Partial Class getText Inherits System.Web.UI.Page Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim theid As Integer = Request.QueryString("id") Dim con As New SQLConnection(ConnectionString) Dim cmd As New SqlCommand("SELECT somefield FROM sometable WHERE id=" & theid) Dim sda As New SqlDataAdapter(cmd) Dim ds As New Dataset sda.Fill(ds) If ds.Tables(0).Rows.Count > 0 Then Response.Write( …

Member Avatar
Member Avatar
+0 forum 5

Hi, I am having trouble with retrieving records on my database. My layout was this.. [CODE]UsersList Username Firstname LastName Role Records TheUser ApprovedBy DateApproved [/CODE] The first text are the table names while the indented once are the field names. I have a table named Records. TheUser and ApprovedBy was referring to the Username under the UsersList table. Now my problem was, when I retrieve the records by aliases. I need to use the first name and last name of the users to generate report. Example: [CODE]UsersList mzip Michael Zip Supervisor xtian Christian Holmes Trainee Records xtian mzip 1/22/2012 4:53:00 …

Member Avatar
Member Avatar
+0 forum 2

Hi. I don't know where the problem is. The next codes is working on Google Chome but not in IE. I haven't tested yet on Firefox. function.js [CODE]function getSheetCount() { var xmlhttp; if (window.XMLHttpRequest){ xmlhttp=new XMLHttpRequest(); } else { xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange=function() { if (xmlhttp.readyState==4 && xmlhttp.status==200) { var txt = xmlhttp.responseText; for(i=0; i<parseInt(txt); i++){ document.getElementById('sheetNo').innerHTML+="<option value=\""+ i +"\">"+(i+1)+"</option>"; } } } xmlhttp.open("GET","excelreader.php",true); xmlhttp.send(); } [/CODE] excelreader.php [CODE]<?php error_reporting(E_ALL); require_once 'Classes/PHPExcel.php'; $inputFileName = 'rf1.xls'; $objPHPExcel = PHPExcel_IOFactory::load($inputFileName); echo $objPHPExcel->getSheetCount(); ?> [/CODE] index [CODE]<label>Sheet no:</label><select name="sheetNo" id="sheetNo"></select>[/CODE] I tried prompting a dialog box on getSheetCount and it shows this error …

Member Avatar
Member Avatar
+0 forum 3

Hi. Can you help me how to balance a chemical equation using linear algebra. I know how to do it on a piece of paper using the usual method of balancing. I just don't get the principle how to do it on the other method. Please give me a step by step procedure on how to do it, the basic ones. This is how far I have gone. Ex: Fe + Cl2 = FeCl3 Set a variable for each [A]Fe + [B] Cl2 = [C] FeCl3 Count the number of coefficients Fe: A = C Cl: 2B = 3C And …

Member Avatar
Member Avatar
+0 forum 2

Hi. I just want to ask if it is possible to create a function that accepts an expression into its arguments. Just like what IIF do. Ex: [CODE]Dim strResponse as String = IIF(Msgbox("Select Yes or No", vbYesNo) = vbYes, "Yes", "No")[/CODE] I forgot the code, but its the thought that counts. Anyway, is it possible? If it is, how? Michael

Member Avatar
Member Avatar
+0 forum 1

Hi. I have this table named tblProduct, which contains fldProductID, fldProductName, fldValue fldProductName contains its name, and fldValue contains how much is the product cost. Now I am having trouble with updating fldProductID. Here's what my fldProductID look like. [QUOTE][B]fldProductID[/B][INDENT]G01 G02 G03 GZ01 GZ02 TX01 TX02 TX03 TX04[/INDENT][/QUOTE] Its format is [ProductPrefix][ID] When ProductPrefix is deleted, all of the productID containing that prefix will be deleted. For example GZ from ProductPrefix was deleted, GZ01 and GZ02 will be deleted. I don't have a problem with that. The problem is the Update, when I changed the ProductPrefix, from GZ to GZX, …

Member Avatar
Member Avatar
+0 forum 2

Hi. I'm having a problem on deleting a record using a function on SQL. DELETE FROM tblServices GROUP BY ServiceID HAVING MID(ServiceID,1,2)='SG' This query shows and error saying: Cannot group on fields selected with '*'. I tried adding a specific field, like this: DELETE ServiceID FROM tblServices GROUP BY ServiceID HAVING MID(ServiceID,1,2)='SG' but it shows the same result. Please help me. Michael

Member Avatar
Member Avatar
+0 forum 3

Hi, I'm quite new with Data Adapter on VB.NET. I'm having a problem with retrieving data on different tables. Example database: [QUOTE][B]BookInfo[/B][INDENT]BookID: HSD993Z Title: Introduction to SQL[/INDENT] [INDENT]BookID: LDJA293 Title: Advance Computer Programming[/INDENT] [INDENT]BookID: KSKL194 Title: Object Oriented Programming[/INDENT] [B]StudentInfo[/B] [INDENT]StudentID: 2938485 FullName: Michael Zip[/INDENT] [INDENT]StudentID: 2949284 FullName: Ray Williams[/INDENT] [B]BorrowerInfo[/B] [INDENT]StudentID: 2938485 BookID: KSKL194[/INDENT] [INDENT]StudentID: 2938485 BookID: HSD993Z[/INDENT][/QUOTE] To get all the list of the Students who borrowed books, the query would be [CODE]SELECT StudentInfo.FullName, BookInfo.Title FROM BookInfo, StudentInfo, BorrowerInfo WHERE BookInfo.BookID=BorrowerInfo.BookID AND StudentInfo.StudentID=BorrowerInfo.StudentID;[/CODE] Now the Fill method on DataAdapter has a parameter of DataSet and SourceTable. I'm confused …

Member Avatar
Member Avatar
+0 forum 8

Hi! I am currently using LZW algorithm for compressing files but it cannot compress multimedia. What possible process am I missing? Is there any method be done before entering the algorithm? Enlighten me please. Any help will do. Thanks in advance.

Member Avatar
Member Avatar
+0 forum 2

The End.