Search results for query: *

Thanks for your reply stefanwagner, This is exactly what I needed to add. Thank you ! I did not know I had to have a flush(), I thought a close() was doing the same thing. Thanks again, I really did not know what was the problem. Dominic

Hi there, I hope everyone here is doing great. I am looking for some hints. In the class I am making, I have the following code : if(counter==3) { WriteIntByByte(some_integer); System.out.println("test"); } And WriteIntByByte is this : static void WriteIntByByte( int x ) throws...

ok, I tried with the &quot;<cfparam name=&quot;FORM.sqlstring&quot; default=&quot;SELECT * FROM tbluser&quot;>&quot; at the top. That way I don't get the error regarding for &quot;#form.sqlstring#&quot;, but I cannot get the sqlstring to be passed from the other page.

Thank you for the time you're taking to help me ! ok.. I tried what you suggested..but I I must have understood it wrong because it didn't work. So, here is the code I use. Server with the DB (Server A) : test_db_server.cfm Remote file (Server B) : test_db.client.cfm (test_db_client.cfm)...

Ok, I did some tests... and it does not seem to matter whether I try to connect from the same server or from a remote server. I always get &quot;connection failure&quot;. Now, I am wondering if it's because I need to install or configure something... like WDDX's SDK ? Do I have to or it's part...

Thanks for the security tip pcorreia. how would one try to find how to solve &quot;connection failure&quot; in such case ? I looked at the passwords several times, looked to make sure the datasource name and all are written exactly the same way...(in the same order even)..but.. I still get the...

thanks for your help, I actually have a different error message now inside the <textarea>. All it says now in it it's &quot;connection failure&quot;. Normally I use the following to connect to the DB <CFQUERY PASSWORD=&quot;#Application.DBPW#&quot...

I have been trying to figure out a way to get this to work for about a month now... since end of June actually. Unfortunately, I have yet to win. In the previous post from pcorreia, I was told the following &quot;You may find the answer if you comment out the <cfwddx> on the Server B page and...

no, ID is not an IDENTITY column and.. the table does not have any. And the ID column contains only numerical values. INTEGER to be more precise.

Thank you for your reply rudy. this table does not have any PK. The ID field could &quot;act&quot; as a PK since there will be only one (if any) instance of that ID in the field. And regarding doing an Insert, then an Update and ignore the error messages... well.. this query is done through a...

Hi all, I have a newbie question in MS SQL 7 Let's start with the following statement UPDATE cyber_pricing SET pricing = 1, description = 'blah blah', stock = 'NO' WHERE id = 12345 This will update the record id &quot;12345&quot; only if it exist,how could one insert the record if it...

Hi All ! Nevermind, I think I found my answer... It looks like all I needed to do is to put the owner of the table in front of the table... so.. SELECT * FROM owner.table1 works perfectly ! Thank you !

Hi all, on MSL SQL server 7, I have 2 different users. One is for me and I had this account for a few years, and recently, I asked my hosting company to create me a second user. However, I cannot get this user to &quot;see&quot; any tables in the database. It always says &quot;invalid object...

Hi there.. I am trying to set up a connection to my database from a different server, but i'm having difficulties. I was given this code to connect... &quot; <% Set conn = Server.CreateObject(&quot;ADODB.Connection&quot;) DSNtemp=&quot;DRIVER={SQL...

Thank you both for your replies. I tried pcorreia's post. But I am getting a little error returned by ColdFusion.. &quot;XML parsing error: syntax error (error code 2, line 1, column 63, buffer offset 63) The error occurred while processing an element with a general identifier of (CFWDDX)...

Hi everybody, I have a database running on a MS SQL Server (let's call it Server A), with a web site on the same server. How can I set up a web page on a different server (Server B)to be able to query my database on Server A without adding an ODBC on Server B ? Like, some code embedded in the...

Hi there... Is it possible that ipmasqadm is not compatible with Kernel 2.4 ? I tried to install the package but RPM gave me an error message saying &quot;Kernel>=2.3.0 conflicts with ipmasqadm-0.4.3.i686.rpm&quot; Is there a way to install this package anyway ? Or another way to do this kind...

Hi, Can we use CASE statements to do something else than select fields ? Like, having two &quot;WHERE&quot; clauses that we can selected using a CASE ? Like... Select TblName.Col1, TblName.Col2,TblName.Col3,TblName2.Col1 From TblName,TblName2 CASE TblName.Col1 =1 THEN WHERE ..... ELSE...

Thank you very much Chelandrew !

Good morning, I would like to do something similar to... --------- SELECT tableA.field1,tableB.field1, tableA.field2,tableB.field2 FROM tableA,tableB IF tableA.field1=1 THEN ( WHEN tableA.field2 = tableB.field2) ELSE ( WHEN tableA.field1=tableB.field1...