Search results for query: *

I have a repeated control that I populate from my MS SQL DB. Now I check one of the returned values, so far I'm using this code: <%If Container.DataItem("fldSHARE") = "1" Then %> <td>Shared</td> <%else%> <td>Not Shared</td> <%End IF%> When I run the code I receive an error: BC30451...

Is there a way to insert records that are returned by a select statement ? I have 2 identical tables, each with the same structure, but different names. I want to query one table and insert the result into another one. I'm using MS SQL. Thanks :) &quot;Taxes are the fees we pay for civilized...

I'm using the following to get the table structure: SQL = "SELECT column_name, data_type, character_maximum_length FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '" & strTABLE & "'" Call OPEN_DB() Dim MyCMD As New OleDb.OleDbCommand(SQL, MyConn)...

I have a DataRepeater that I bind my data to, now I want a checkbox to be placed in each item and then when I click the button I want to get list of values from those checkboxes. How can I do that ? For some reason I can not reference controls I place in the <ItemTemplate> of the DataRepeater...

I have 2 tables, 1 containing categories (parent) and another one containing sub-categories (children). The sub-categories table has a reference to the parent in fldPID field: CREATE TABLE [tbl_m_cate] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [fldNAME] [varchar] (150) NULL , ) ON [PRIMARY]...

I have a module where I keep all my common functions, now I want to use one of the functions like this in the page.aspx file: <td align="Center"><%#CONVERT_TXT(Container.DataItem("fldACTIVE"))%></td> The function CONVERT_TXT is decalred pulic in the module. When I put the function in the...

My questions is very simple (I think) I'd like your opinion where to open the DB connection. In classic ASP I'd open the connection near the top of the page where I'd need it and close it with the last trip to the DB near the bottom of the page. I'd only have 1 connection per page. Can I...

How can I get a simple return of data from my DB using ASP.NET (VB.NET). In classic ASP I'd do something like this: SQL = "SELECT COUNT(ID) AS C_COUNT FROM table" Set RS = Server.CreateObject("ADODB.Recordset") RS.Open SQL, MyConn IF NOT RS.EOF THEN COUNTER = trim(RS("C_COUNT")) END...

Whatever happened to the folder, drive and the file list controls in VB.NET ? Isn't there a control I can drop on my form and use to browse folders and files ? &quot;Taxes are the fees we pay for civilized society&quot; G.W.

Why doesn't this query works ? UPDATE tbl_settings SET fldPATH = 'E:\psa\vhosts\', fldURL='1', fldEMAIL='service@mc.com', fldSMTP='3', fldSHOW_NAMES=1 WHERE ID = 1 The error is: [MySQL][ODBC 3.51 Driver][mysqld-4.0.16-nt]You have an error in your SQL syntax. Check the manual that...

I'm using this function to phrase the text (strDES) for occurrences of words (arrKEYS) and I highlight them using the RegEx. The problem I have is that it highlight text that is between the HTML tags it created, more specifically the <span class='spanMATCH'>$1</span> Is there any way to tell...

Here is my problem, I have an application that gets distributed all around the world and it relies heavily on dates. (It runs on both MS Access and MS SQL) When I need to insert today's date I simply use the Now() for MS Access or GetDate() for MS SQL. This works nicely in every country and...

Hello All, I have a question, which you might be able to help me with :) I have an ASP application that gets installed on many servers, some of them Win 2003 some Win 2000 some NT4. As you probably know on Windows 2003 you can no longer use: <!--#include file="../../file.asp"--> but rather...

Hello, I have a select (<select></select>) element which is populate from the DB, each item has a numeric value. When I click the preview button the ID gets passed to an iframe. My question is: How can I check that an item was selected before I send it to the iFrame ? function...

Hello All, I'm wandering how I can work with a value pulled from a database before it gets flushed in to the DataList. Here is an example: Field fldActive in my DB is either 1 or 0, when it's 1 then I want to show it as 'Active' and when it's 0 then I want to show it as 'Inactive'. How...

Hello All, I'm trying to return the number of records I have in my DB for each month of the last year. This is what use so far: SELECT Count(ID) AS C_COUNT FROM exp_tbl_order WHERE fldDATE >= '12/01/2003' AND fldDATE <= '12/31/2003' Is there a way to create it dynamically, whereby...

Hello all, I have an application that needs to be in more then English language. Now, what would be the ideal way of dealing with the translations. I only want to have 1 instance of the application, and include language files with it, so the user can just select what language to use and be...

I'm just wandering if it is possible to retrieve words that are included in the text field most often. So for example content: Hello, how are you ? Is that it ? How you doing ? How is that ? Would produce words: how (3 times) is (2 times) that (2 times) Is this doable without using stored...

Hello all, I have a small problem I need help with :) I have a table called tbl_down, this table has 2 fields ID, fldCOUNTRY Now I want to select unique countries and how many times they occur. I'm using this query: SELECT fldCOUNTRY FROM TBL_DOWN GROUP BY fldCOUNTRY How can I get the sum of...

Hello all, Just wandering if it is possible to force a new pop-up window to always stay on top of the parent. I don't need to set focus on it, just to sty on top. So you'd be able to wok on parent window and yet still see the pop-up window. &quot;Taxes are the fees we pay for civilized...