Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Showing results 1 to 25 of 106
Search took 0.02 seconds.
Search: Posts Made By: Corey
Forum: Beginning PHP April 17th, 2007, 11:01 AM
Replies: 1
Views: 1,452
Posted By Corey
Search and Replace Using SQL Oracle i9

Can anyone show me a easy way to do a find and replace using SQL Oracle i9

Example
Select row1
From table1
Find ‘123”
Replace with ‘ABC

Thank you for your help
Forum: Access March 20th, 2007, 08:09 AM
Replies: 6
Views: 3,280
Posted By Corey
That is can be any number 0 through 9

That is can be any number 0 through 9
Forum: Access March 19th, 2007, 04:09 PM
Replies: 6
Views: 3,280
Posted By Corey
Hi Again, can anyone help me identify why I'm...

Hi Again, can anyone help me identify why I'm getting zero records returned, when I know I should be getting over 10,000 records

SELECT *
FROM emtadmin_BD.NESSAGE
where(NESSAGE_NOTES) Like...
Forum: Access March 9th, 2007, 04:07 PM
Replies: 6
Views: 3,280
Posted By Corey
convert a SQL Statement from MS Access to a SQL

Hi everyone.

I'm trying to convert a SQL Statement from MS Access to a standard SQL statement.

Could anyone help me understand how I do this?

HAVING (((EMTADMIN_DR_MESSAGE.MDATE) Between...
Forum: Access March 1st, 2007, 11:11 AM
Replies: 1
Views: 1,227
Posted By Corey
Wild Card Help *

Please help me find out why this formula isn’t working right.
I’m able to run my query, but it seems like the wildcards around
the “LAM” is not working. Is there another way I can put this...
Forum: Access February 28th, 2007, 10:08 AM
Replies: 3
Views: 2,674
Posted By Corey
Martin, That didn’t seem to work with, I...

Martin,

That didn’t seem to work with, I didn’t get any error, but when I try to run it, it gives me the “Enter Parameter Value” box asking for “qry_Symantec_email_Circ_A2_3!Site_ID”...
Forum: Access February 27th, 2007, 06:31 PM
Replies: 3
Views: 2,674
Posted By Corey
Invalid bracketing of name

Help

Can someone please tell me why I'm getting this error?
Why am I getting this error message?

Invalid bracketing of name

This is what I have:

Site_ID:...
Forum: Access February 20th, 2007, 09:35 AM
Replies: 4
Views: 1,433
Posted By Corey
The queries are made up of Access and some SQL...

The queries are made up of Access and some SQL Pass Through queries. My Database is pulling from an Oracle Database
Forum: Access February 19th, 2007, 03:31 PM
Replies: 4
Views: 1,433
Posted By Corey
Increase The Performance Of My Queries

I’ve been working with some very large databases, which are taking a long time to run

I am hoping I can get some advice on how I might be able to increase the performance of my queries?
...
Forum: Oracle February 15th, 2007, 12:18 PM
Replies: 2
Views: 1,741
Posted By Corey
and the Tables open very slow also

and the Tables open very slow also
Forum: Oracle February 15th, 2007, 12:12 PM
Replies: 2
Views: 1,741
Posted By Corey
MS Access connecting to Oracle Problem

I have two computers at my desk. Both have MS Access and connect to Oracle.

Both say that they connected successfully when I do a “Test Connection)” but the problem I’m having is that one of...
Forum: Access February 15th, 2007, 11:23 AM
Replies: 2
Views: 9,364
Posted By Corey
Thanks Scandalous

Thanks Scandalous
Forum: Access February 15th, 2007, 11:15 AM
Replies: 2
Views: 2,656
Posted By Corey
Oracle back-end MS-Access 2003 client front-end

Hello everyone. The company I’m working for is looking to convert my MS database into a Oracle database.
Can anyone tell me the advantages and disadvantages of a Oracle back-end with a MS-Access...
Forum: Access February 13th, 2007, 11:04 AM
Replies: 2
Views: 9,364
Posted By Corey
Convert Snapshot Viewer to a PDF file

Does anyone know of a way I can convert Microsoft Snap viewer to a PDF file.
Forum: Access VBA February 5th, 2007, 10:41 AM
Replies: 4
Views: 6,674
Posted By Corey
ok, sorry

ok, sorry
Forum: Access February 2nd, 2007, 11:16 AM
Replies: 1
Views: 4,907
Posted By Corey
Making a number negative

Hi again everyone,

I'm working on being able to subtract the cost of returns against the cost of shipping.

The formula would go something like this

Program ID:...
Forum: Access February 2nd, 2007, 10:12 AM
Replies: 1
Views: 4,872
Posted By Corey
Convert SQL to MS Access

Hello everyone

Can anyone help me convert the sql statement below to a statement I can put into Microsoft access, or help me brake this down so I can put it into access.

Thanks
Corey

...
Forum: Access January 31st, 2007, 02:12 PM
Replies: 1
Views: 967
Posted By Corey
How can I Speed Up My Queries

Hello everyone.

I'm looking for ways that I can speed up my database, mostly the queries that I download from the Oracle ODBC.

Thank you

Corey
Forum: Access VBA January 26th, 2007, 04:05 PM
Replies: 4
Views: 6,674
Posted By Corey
Run code in Macro

I am trying to create a macro that will run
this code by using Runcode action.


The code is show below. What do I need to do to make this work.

#CODE#
Public Function SepData()
Dim rst As...
Forum: SQL Language January 17th, 2007, 10:59 AM
Replies: 3
Views: 1,797
Posted By Corey
Quest Software “TOAD”

I’ve recently been introduced to the Quest Software “TOAD”

Now I’m just trying to gather some resources of were I can go and get feedback to questions I know I’ll have down the road. For...
Forum: Access December 15th, 2006, 10:20 AM
Replies: 1
Views: 9,086
Posted By Corey
[Oracle][ODBC][Ora][ORA-01013

Hello again

I’m trying to understand why I’m getting the message below and how I can fix it.
This happens when ever I try to run a larger qry, and it pops up within a minute.

Any help...
Forum: Access December 14th, 2006, 11:10 AM
Replies: 2
Views: 1,242
Posted By Corey
Awesome - Works great!!!! Thanks a lot...

Awesome - Works great!!!!

Thanks a lot Martin
Forum: Access December 13th, 2006, 04:13 PM
Replies: 4
Views: 1,745
Posted By Corey
Let me see what I can put togehter... ...

Let me see what I can put togehter...


Thanks
Forum: Access December 13th, 2006, 04:12 PM
Replies: 2
Views: 1,242
Posted By Corey
Help with IIF Statment

Hello everyone,

I'm trying to put together an IIF statement that goes something like this

iif ([field1] = 51245 then go to ([field2]
and put "156354"

iif ([field1] = 12548 then go to...
Forum: Access December 4th, 2006, 12:03 PM
Replies: 4
Views: 1,745
Posted By Corey
Finance forecast Database

Hello everyone,

I’m looking for some help on creating a Database that can analyze and determine a company’s future financial income by using key automated analytical tools that I would be able...
Showing results 1 to 25 of 106

 




Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.