Search results for query: *

Doing as you wrote, I ended up with a '0' as id. Tried setting it to NULL, but didnt succed. Might be my fault since I dont know how to. wrong? insert into tmp_skatt(id,ewc,vikt) select NULL, 'Allt in', ifnull(sum(trans2009.nettovikt),0) v.... says that 'id' cannot be 'NULL'. /Hylsan

I tried that I believe. Gonna give it a go again...thanks! /Hylsan

but how do I write the line; insert into tmp_skatt select trans2009.transnr, 'Allt in', sum(trans2009.nettovikt) vikt from trans2009 ..... Its the "trans2009.transnr" I would like to change so that it is using the "id" instead. /Hylsan

...Got a stored procedure that looks something like this; CREATE TEMPORARY TABLE tmp_skatt (transnr INTEGER, ewc VARCHAR(50), vikt DOUBLE); /* Plockar ut "allt in" */ insert into tmp_skatt select trans2009.transnr, 'Allt in', sum(trans2009.nettovikt) vikt from trans2009...

Yepp, helped alot! Thanks! /Hylsan

...$$ DROP PROCEDURE IF EXISTS `vagsql`.`pVisaIntern` $$ CREATE PROCEDURE `vagsql`.`pVisaIntern` (dat1 varchar(20),dat2 varchar(20)) BEGIN /* starta överkopiering av artiklar till temp-tabell */ /* Ska ersättas med CREATE TEMPORARY TABLE */ insert into tmp_artikel select artikel...

Hi! I've got a SP (pVisaIntern) that makes two temporary tables and makes a combined result. It has two inputs and all works fine in query browser. How do I call this on my page? <?php include "../connect.php"; // HTML-tabellens formatering - tabellstart echo "<table border='1'...

Thanks for your answer! It looks like it could work. Ive ran the SELECT and the values look alright, but I must admit I fail to completly understand the whole sequence. The INNER JOIN, does it makes a copy of the table temporary? Looks like it but Ive never used it before. Thanks again! /Hylsan

Hi! Ive got a table with these colums; id, vanl_nr, vtax_kod If I do a simple select-phrase like this; SELECT vanl_nr, vtax_kod FROM list where vtax_kod='vh6' I'll get a couple of rows like this vanl_nr vtax_kod 2423421 vh6 2333244 vh6 3232333 vh6 1232344 vh6 Now the...

Hi Im aso having trouble with OWA(for outlook2000). My config is; ------------------------------------------- IX Version 5.2(6) nameif ethernet0 outside security0 nameif ethernet1 inside security100 enable password XXX encrypted passwd XXX encrypted hostname cortecpix fixup protocol ftp 21 fixup...

Hi I know this is a question many before me have asked on this forum but I hope you can bear with me. I need to open up port XXXX for webaccess, but I have never worked with Cisco pix 506 before(or anything else made by Cisco for that matter), so I need someone nice to help me out on this one...

ok, my misstake...what I ment was; What I ment was, I want the code to look like the one in the code-snippet(if you run that, it complains about table not exists). Everything works except when inserting the variabel "srvPath" into the "shallow traversal", i.e changing srvPath to...

If you do, try not to backup your exchange twice (i.e both on c:\Program Files\Exchsrvr\MDBDATA\ and the information store checkbox...use the latter for best performance) just my 5 cents... /Hylsan

Hi Im using ADO and the Exchange oledb-driver to access exchange public folders, but I have a little problem. I want the program to use a variabel to store the full path to the server and then use it in the SELECT statement, as follows; dim srvPath as string = "http://server/public" sel =...

Hi Have anyone tried interacting with Exchange with help of ADO.NET and VB.NET? MSDN have some papers on how to use the old ADODB/CDO and exchange but im thinking of imigrating all to .NET and just wondered if it can be done in a similar way. /Hylsan

Hi I would like to enable this litte thingy, but i have absoulutly no idea how. Ive read on MSDN and there it says something about adding some code into application.exe.config, but not what this is/lies. Im new to vb.net and never used it in vc++ so all help are appreciated! Ive enabled it...

Ive got one font we use, dont ask me where we got it from though couse i have no idea. I can mail you the font if you'd like, to use at youre own risk ofcourse :) /Hylsan

Sadly the new mdac didnt help, same message. I reinstalled the app aswell. Will it help installing vb.net on the machine? Its not a good way, but if nothing else work we have to do it until ive made the .NET version. /Hylsan

Thanks for your reply, ill check that out today. I am gonna convert it to .NET but currently i dont have the time. /Hylsan

...server, its a sbs2003 (same as our testserver) but it has probably been upgraded from nt/2000. when trying to run the program i get this error; ************** Exception Text ************** System.Runtime.InteropServices.COMException (0x80150804): Exception from HRESULT: 0x80150804. at...