Jerome

If it's asking you to log in, does it mean the containt you are looking for is restricted... or there is a problem with the asp code... Just paste the URL or some code...

Hi,How do you format the content of your mail? Could paste a bit of your code?

The '&' caracter allows a bitwise logical AND operation between two integer values. That means that the expression "Flag & 4" permits to compare two numbers at bit nivel. Here is a complete explanation.

Yes, you are right.The only (and fastet) solution would then be a store procedure if you where using sql server...

I'm not sure but are you mixing an SQL query with asp code? Or in wich language are you writting?

Hi, I visit this forum almost daily trying to find some answers or to give some to others.I think the forum is really well done althought I have one suggestion. I saw on a french forum a kind of "answer validator". When a topic is posted, people start to give some answers and at the same time the forum-staff is watching. When an answer is valid (and of course tested) then they put some icon next to the topic to inform the users that the problem has been solved. They even give some points for the answer (like 7/10). I'm sure this could improve a little more this forum... or what do you think?

I do not fully understand wich answers you are looking for. Could you pls explain a little more or/and paste some of your (problematic?) code.

Hi Pauly,Could you let us know if it works? If you need some help concerning the asp code, i can help you.Happy programing

Hello Pauly,I never tried this with pdf's and did'nt have the time to investigate it but here is a link that seems to give a complete answer : http://www.15seconds.com/issue/990902.htmHope this can help you.

I'm not sure this is the best solution to your problem, but I would relate your records (A,B,C) to an ID field, then construct the query like this : <%@ Language=VBScript %><%Dim Con, Rst, actualID, previousID, nextIDSet Con = Server.CreateObject("Adodb.Connection")Con.open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("yourBase.mdb") & ";" Set Rst = Server.CreateObject("ADODB.RecordSet")actualID = 2 'this id is related to field that contains your B recordpreviousID = actualID - 1 'here you look for the previous idnextID = actualID + 1 'here you look for the next idSQL = " SELECT records FROM yourBase WHERE id = '" & previousID & "' OR id = '" & actualID & "' OR id = '" & nextID & "' "Rst.Open sql, ConIf Not Rst.EOF Then Do While Not Rst.EOF Response.Write(Rst("records")) Rst.MoveNext LoopEnd IfRst.CloseSet Rst = NothingCon.CloseSet Con = Nothing%> Hope this helps,Cheers

Of course you can store images (sounds, flash animation,...) into an Access or an SQL database, but it's really huge and it could be dangerous for the stability of your database. If you still want to do it, you have to options:- insert your images manually in a OLE OBJECT field of your database.- insert them dynamicly in your data base using some inserts or updates statments and an asp or a php function to first decode your image in their binary code.But, as it was mentionned before, the best way would be to store the path of your images in your database and to put your images on your server. That would be my choice.Happy programing Jerome

Hi,I just tried your code on my server and it worked fine with IE and with FireFox. I only had to change your picture with one of mine. I suppose that the name/extension of your image is not right : It should be something like : no?Kind regards from MexicoJerome

Hi Xander,What exactly are you trying to do with your query? What type of values contain your columns?If you want to use the GROUP BY clause, your selected columns (SubKategori, TutKategori, TutTittel) need to be part of an aggregate function (like SUM, COUNT,...). More info here...Cheers,Jerome

Hello Frans!Could you copy/paste your code? Thanks, Jerome

Hi,Could you please send us the error message and the part of the code where you make the connection to your local database? Jerome

Hi Maelstrom,Everything is clearly explained here : ServerVariables CollectionConcerning the current user ID, I suppose you are talking about the session object, check Session Object out. Jerome

My question: what do you mean?

Hi cegger,I'm maybe wrong but you should change your condition from : <% If (rsBuilderInfo.BOF = TRUE) AND (rsBuilderInfo.EOF = TRUE) Then ... %> to <% If (rsBuilderInfo.BOF = FALSE) AND (rsBuilderInfo.EOF = FALSE) Then ... %> If it's false that you are at the beginning of the file (BOF) and at the end of the file (EOF), then you execute your select.Jerome

Hi bairdb,You should use an onChange event in your first combo box, then catch the variable you selected to build the second combo box. Here is my version, you just need to add your connection.inc and your 2 queries. Hope it will be helpfull,JeromecmbBox.asp<%@ Language=VBScript%><!-- #INCLUDE FILE = "../connection.inc" --><%Dim cmbItem1, cmbItem2 cmbItem1 = Trim(Request("cmbItem1"))%><html><head><title>Combo box</title></head><body><form name="frm" method="post" action="cmbBox.asp"><!--Here, you should insert your loop and your sql query to populate the first combo box...--><select name="cmbItem1" onChange="submit();"><option value="">- - - -</option><option value="Item1" <%If cmbItem1="Item1" Then Response.Write("SELECTED") End If%>>Item1</option><option value="Item2" <%If cmbItem1="Item2" Then Response.Write("SELECTED") End If%>>Item2</option><option value="Item3" <%If cmbItem1="Item3" Then Response.Write("SELECTED") End If%>>Item3</option></select><%'Use the variable cmbItem to make your second sql query and populate the second combo box...If Len(cmbItem1) Then Response.Write("<select name=""cmbItem2""><option value=""" & cmbItem1 & """>" & cmbItem1 & "</option></select>")End If%></form></body></html>