|
by: greg.kujawa |
last post by:
I am passing along an Index Server 2.0 query though URL strings calling
the ASP. I am searching for records by a person's last name and their
phone number. Something like:
http://myserver/query.asp?ciRestriction="lastname"%20and%20"555-1212"
Here is the chunk of code that processes the query request:
ciRestriction =...
|
by: DL1 |
last post by:
I am trying to pull data out of my SQL 2005 server using Excel. I have the SQL query working properly; however, I want to modify a portion of the query (the date) with a prompt to give me the results I need.
I want a button/macro to prompt me for the date I want to reference. Take that information and change the date in my SQL query to match....
|
by: Henrik Juul |
last post by:
I have the following 2 tables:
(BATCHES)
BatchID KEY
ID
OrderID
Action1DateTime
Action2DateTime
Action3DateTime
Action4DateTime
|
by: ambelkar |
last post by:
hi,
I trying to join weekly & daily tables by using end_dte,Rpt_dte respectively.My week is saturday to friday.first table only having week end' dates but the 2 daily table having daily dates .when I trying to join 2 tables using the following condition
weekly.end_dte=Next_day(daily.rpt_dte,'FRI')
only for this friday's date it displays...
|
by: axlq |
last post by:
I'm trying to figure out a MySQL query expression to match an email
address. Here's the situation:
User registers on my site with a "plus style" email address
(username+key@example.com). This is a perfectly legal address and I
don't want to disallow it, because I use this style myself and find
it useful. For example...
|
|
by: socc16e |
last post by:
I have an excel sheet that I have imported into SQL 2000 and I need to match the values in one to the values in another and have them output the matching codes to a separate table or file.
After re-reading that, it doesn't make a whole lot of sense, so let me give you an example.
In one table I have 3 columns: Name, Description, Number. ...
|
by: csolomon |
last post by:
Hello:
I am trying to put together a query that determines employees who are in a department that has had an incident with in the last two months. I have a query that determines who has had and incident and the department they were in when they had the incident:
SELECT Q_RestrictedEmployees.empID, Q_RestrictedEmployees.empNo,...
|
by: Pat Rowe |
last post by:
Relative Newbie w/ a stumper! Any help is appreciated. Thanks!
I have two tables that I have imported to access. I'd like to query between these two tables for records that have a shared last name (under a name field) in both tables.
It's a bit complicated because the name fields in the two tables are formatted differently, and sometimes...
|
by: Neil Chinneck |
last post by:
Hi everyone,
I'm looking for some help please. I have a continuous form, with several fields which can be filtered using combo boxes. Once the user has filtered the form, I want them to enter values into a series of text boxes and then use these values to update the filtered records, and only the filtered records.
I have an update query, but...
|
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...
|
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. ...
|
|
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...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
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...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
|
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...
|