473,626 Members | 3,291 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Work Around- Using the IN Statement with Parameters

I hate using Dynamic SQL and was prohibited from doing so b/c we couldn't
use 'IN' Statement in the where clause with Parameters which broke out data
access block. I wrote a work around which works, but I did it in haste.
I'd really like some feedback (be harsh, I'm not thin skinned) and would
like to improve it. Here's the link..
http://www.knowdotnet.com/articles/temptables.html It's based on a VARCHAR
field, but could easily be enhanced with another overload. Any feedback
would be appreciated.

Thanks,

Bill

--
Cordially,

W.G. Ryan
do********@comc ast.nospam.net
www.devbuzz.com
www.knowdotnet.com
Jul 21 '05 #1
0 1022

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

18
1371
by: Stephen Waits | last post by:
Occasionally we want to perform a Sqrt where we don't need accuracy and/or we have a good initial guess - a situation where an N-step Sqrt series may be more optimal than a full on Sqrt(). For example: template <unsigned int iterations> T SqrtApprox(const T x, const T guess) { return SqrtApprox<iterations-1>( x, T(0.5f) * (guess + (x/guess)) ); }
25
1574
by: Steve Lefevre | last post by:
Hey folks - I'm working on an access database that I'm hoping to be able to sell to small/medium sized business. I would like to do some trial and demoing, but I'm worried about client's ability to undo the security measure that I put in place. Specifically, I know that holding the 'shift' key disables all startup options on launch, so that cancels any ability I have to shut down a time-period demo. How have you done it?
7
1144
by: Pixar Film Rock | last post by:
I'm a newbie, bear with me here. It has one .exe file, is this where all the instruction is stored? Everything else is just data like textures, maps, etc? How do these crackers hack the .exe so that you don't need cds in the drive to play these games? And there are also DLL files which have methods/functions too, right?
15
1903
by: Brett | last post by:
I'd like to know what management and the work environment are like where you work. I need something relative to compare my current work environment. Here's a few questions I have: 1.) Is it normal for (technical) management (actually 1 of 2 co owners) to constantly interrupt developers all day with with questions such as: "can we look at this", "I found this, can we try it now", "Can we see what these guys are doing", "can we change...
1
1428
by: somanyusernamesaretakenal | last post by:
Hi everyone, I am working with Access 2003. I know a crosstab query only allows 1 value field, but how to do you around this restriction? I have a table with let’s say customers, products, calendar year (this field include year 2005-2007), months and a number of expense fields. I was told that to get the sums of products (expenses) per year I need to create a crosstab query. The problem is that some expense fields are added together or...
14
3471
by: webEater | last post by:
I have a problem, it's not browser specific, and I don't get a solution. I have an (X)HTML document, I show you a part of it: .... <!--<div class="pad">--> <div id="eventImages"><img src="" id="eventImage0" class="eventImage"><img src="" id="eventImage1" class="eventImage"></div>
14
1466
by: snapple | last post by:
I created a game called Mystic Crusade (www.mysticcrusade.com) and it tends to work perfectly except for one thing, sometimes it doesn't register the session, i guess. For some reason, some of my users have to log in several times before they are logged in to stay. This is what I mean... Most users log in and it takes them to their "home" page, then they can move around and do stuff in the game. But some users log in, it takes them to...
0
1529
DressageRider
by: DressageRider | last post by:
I need your help. Desperately. Someone has to be able to fix the utter balls up I've made after dinking around in Flash for the last four days. I have no prior knowledge of anything other than how to point and click, so I figured the fastest way to get comfortable with both Flash and Dreamweaver was to immerse myself in them and see how fast I wanted to commit suicide. If you can seriously look at this stuff for more than a day or two in a...
0
1378
by: kirby.urner | last post by:
This archival (yet recent) posting to an obscure physics list might be of some interest to those taking a longer view. The work/study projects described below come from an Oregon think tank working in private-public partnerships on education policy. I'm one of the principals. Kirby =====
0
1198
by: Steve | last post by:
Hi guys, I am working on a Team Process Template for TFS 2008. I have created my own work item type, which has (amongst other controls) a HTML control to hold process guidance text: <FIELD name="Purpose" refname="Microsoft.VSTS.CMMI.Purpose" type="HTML"> <HELPTEXT>The purpose of the review</HELPTEXT> <REQUIRED/>
0
8262
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8196
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8701
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8637
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
7192
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
4090
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4196
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1807
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1507
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.