Search results for query: *

I see. Thanks again Jason

Hi Jason Thanks very much for letting me know. I'll take a look at the links you kindly provided. Many thanks.

Hi there. I'm so inexperienced in coding, it's embarrassing!!! I am using VWDE as a means to allow users to load an image from their own machine's directory into an image control, without having to store the image in any back-end database (i.e. directly from their machine). An example would...

Thanks jshurst Another snippet of knowledge that I shall add to my growing arsenal. Also, thanks for5 your help throughout what has been a torrid time for me. And thanks to jbenson I stand corrected.... said the man with the othopaedic shoes. DixieDean

Hi jshusrt and c8msm Just to let you know I've cracked the problem. It was parameter-oriented, but nothing to do with how the front-end was compiling them or how they were being sent through to SQL. At the risk of being branded an imbacile, but with the intention of helping others to avoid...

Hi jshurst Just to keep you abreast of efforts at my end. I undertook a number of alternative approaches to try to ascertain if there were any particular anomalies occurring when certain aspects of the procedure were amended. 1. I removed the UserCode parameter from both the SP and VB...

Hi jshurst Many thanks for looking at this for me. Here is the SP (sp_EvNIInList) and also a function that I ripped from another web site. This function (called “Split”) receives a string of delimited values and “splits” them into individual search criteria, which are then placed in the IN...

Hi c8msm Thnks a lot for helping me out with this quandary. I tried to apply your advice to this problem. I used the following code. Please note that I removed the initial Parameters.Add method and replaced it by creating two parameter objects and assigning their properties as suggested...

Hi jshurst Thanks for your last response. Your help is most welcome and appreciated. I tried applying your suggestion to resolving this problem, but, I’m afraid, to no avail. However, I have made some assumptions with regards to the code you posted. 1. I assume that the two parameters you...

Hi ca8msm Thanks for your response. I'm afraid I'm a real novice at this. I would really appreciate it if you could provide an example of creating a parameter object and setting its properties accordingly, particularly if you could place it in the context of this problem. Many thanks in...

Hi jsHurst Sorry to keep bothering you with this, but I've just ran a similar routine without any parameters and .... yep, you were right. It works fine. It's the darn parameters that are causing the problem. However, due to the need for these parameters, as any hard coding of search...

Hi jshurst I've done as advised (i.e. removed the connection open and close elements). I eagerly await your help with this. It's driving me crazy. Thanks very much for your assistance. DixieDean

Please, can anyone help me? I am a newbie to SQL Server Express 2005 and VWD Express, and I’m currently working on a personal project that consists of a relational database back-end (SQL SE 2005) that holds sports event data (i.e. number of participants, winner and date of event, etc), which I...

Thanks for the quick response. I'm afraid I don't really have an example to offer, as I'm merely trying to understand how to get the DateRange label to display the string and the incorporated output values of the stored procedure. The truth is that I don't know where to start, as most of the...

Hello Please help. I am a total novice with VWDE, and would be most obliged if you could overlook my general ignorance and help me with this issue. I have a web form called Demo.aspx which incorporates a label (DateRange) that I would like to display the earliest and latest dates when a user...

gmmastros, thanks very much for pointing me to the solution. It works a dream. If you're ever in Liverpool, let me know, 'coz I owe you a huge drink. Many thanks and merry christmas. DixieDean

Please stop me from going insane. I am but a humble, inexperienced developer, and I’m currently developing a web-based system, using SQL Server Express Edition 2005 as the back-end database application, and I have a parameterized stored procedure that I want to accept a parameter called...

Hi Zameer Many thanks for your help. It's very much appreciated. Regards DixieDean

Hi Helpers I am a MS Access numpty that needs to find out how I can use a multi select list box as the basis of the criteria used in a select query. I have a list box on a form from which users will select a number of options. Each selection will be placed into an “In (…” list within the...