Search results for query: *

Now I'd like to take it a step further, i need to display other fields, so how would I change this... select [field3], [field4] from mytable case when field1 is null then field2 else field1 end I get error message.

Thank you hmckillop It worked !!! :)

correction to my post: "result output: 2, then 3" no, it should be 1 then 3.

How would you implement this in an SQL Statement: "The logic you could add to the Sql statement is to get the value from a different column in your table if the value you are fetching from the current column is NULL. EXAMPLE: Table1 Columns are: "A" and "B" If the data in "A" is null, use the...

Hello I'm trying to retrieve all of my events where an event ID equals '11/20/2004' for example. However, the trick is that I want my query to pull all of the events that occur on the 20th of november AND LIST ALL OF THE REST OF THEM *After* that date... can anyone help with this? Thanks! :) AB

Hi I want to create a Windows Service which sends email every week to me. In the email is a copy of the data from one of my tables in a sql server database. How difficult is this to do and does anybody know how to do it?

Look at the code below. I am creating a search form with textboxes. Then, the query gets created, and is added to SSQL. I'm having a problem with the AND -- where to put the AND command eg. select * from table where this = that AND ... etc. etc. -- Thanks! AB 'Create Where Clause Based on...

Hello, I have a one-to-one relationship in in access project adp. problem is, how do you make sure that the foreign and primary keys are ALWAYS the same that they MATCH... is there some kind of rule you can do? Asaf

Hello i need to create one-to-one relationship in ADP project access 2003, so i drag my PRIMARY KEY from table1 to table2, and use the command: select table1.t1, table2.td from table1 inner join table2 on table1.id = table2.id but when i go to the form every tim ei put something in it says...

Anyway to make an Executable from an ADP file (project) NOT MDB. Visual Studio Tools for Microsoft Office System says you can make EXEs from Access databases, but there is no indication of EXEs from projects (i.e. those that connec tto Sql server. AB

Hello, I'm trying to create a Windows Form which shows records. Then when you hit preview, a window pops up and you see a report. then you hit print and it prints. How do you do this. I'm going from ACCESS VBA to VB.NET for an application test. Is this very difficult to do with VB.NET?

Hello, I have a pulldown which is linked to a table. Then I have other fields. How do you do it so that after you select something from the pulldown it automatically populate the other fields in the form by looking at the table. I.e. you have a product which has a description. If you choose...

Hello, have any of you played around with the new login controls? And how baout the personalization features. Does anyone know how to add more columns t othe CreateUserWizard, such as Firstname, Lastname, phone number, instead of the generic ones that come thanks ab

Hello, how do I retrieve data for a specific row using a dataset. I want to fetch the 3rd row information. <%@ Page Language="VB" %> <%@ import Namespace="System.Data" %> <%@ import Namespace="System.Data.SqlClient" %> <script runat="server"> protected test as string Sub Page_Load(sender As...

Hello, I'd like to be able to use the DataReader to control each row manually and proceed to the next. Like this: Fetch my data, then put row 1 information in an ASP:LABEL, then go to the next row (row 2) and put that information in anther label. If there is NULL data in next row, don't do...

thanks

Hello, I have a problem. I have a textbox with a Search button. You enter the description in the box, then hit the button and within the same page, the saerch results come up. However, if you hit ENTER instead of the acutal BUTTON, it does NOT work! (You can try it yourself go to...

Too many arguments to 'Private Function Highlight(spcShow As Object) As Object': CODE Private Function Highlight (spcShow As object) If spcShow.Equals(DBNull.Value) Then Return "" End if End Function Goal: I have a datalist and I want to check for nulls, if it is null, do not display...

Hello, I'm getting an ASP.NET error which says "Maximum number of connections reached - please increase max pool size." Here is my full code, please help me out - I've issue close commands all over the place to make sure there are no connections being leaked. Can someone find something wrong...

Hello, I've been looking for an implementation of pagination for a datalist which is very simple, but so far all of them failed. Any suggestions? Ab