ASP Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsProgrammingASP Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old July 2nd, 2008, 11:09 AM
sweetorangepie's Avatar
sweetorangepie sweetorangepie is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Oct 2007
Posts: 141 sweetorangepie User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 14 h 3 m 37 sec
Reputation Power: 2
Database - General - 80040e14 Error

Hi, I'm trying to access a query in a access database where one of the field's is made with a module. This works fine offline but when I try and use it with my asp i get the following error:

Code:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'  [Microsoft][ODBC Microsoft Access Driver] Undefined function 'Salutation' in expression.  /td/aspmailinglist/includes/_configuration.asp, line 101 


The function Salutation is the one in the module in access.

Does anyone have any ideas why this is or what I can do about it?

Thanks Very Much!

Reply With Quote
  #2  
Old July 2nd, 2008, 11:24 AM
Guddu's Avatar
Guddu Guddu is offline
Contributing User
Click here for more information.
 
Join Date: Jul 2005
Location: Oxford UK
Posts: 3,652 Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level) 
Time spent in forums: 2 Months 3 Weeks 2 Days 13 h 7 m 16 sec
Reputation Power: 787
please post your code here.
__________________
Nothing is Impossible bcoz IMPOSSIBLE itself says..
I M POSSIBLE........................
Be cool !!!!!!!!

Reply With Quote
  #3  
Old July 2nd, 2008, 11:28 AM
Guddu's Avatar
Guddu Guddu is offline
Contributing User
Click here for more information.
 
Join Date: Jul 2005
Location: Oxford UK
Posts: 3,652 Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level) 
Time spent in forums: 2 Months 3 Weeks 2 Days 13 h 7 m 16 sec
Reputation Power: 787
hi
i thinl 'Salutation' is function written in your asp code.in sql query u can use only built in function of access/sql server.u can not use function which written in asp.

Reply With Quote
  #4  
Old July 2nd, 2008, 11:41 AM
sweetorangepie's Avatar
sweetorangepie sweetorangepie is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Oct 2007
Posts: 141 sweetorangepie User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 14 h 3 m 37 sec
Reputation Power: 2
its not an asp function, its a module in the access database.

Reply With Quote
  #5  
Old July 2nd, 2008, 11:49 AM
jmurrayhead jmurrayhead is offline
Moderator
ASP Free God 17th Plane (13000 - 13499 posts)
 
Join Date: Feb 2004
Location: Reston, VA, USA
Posts: 13,091 jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)  Folding Points: 86637 Folding Title: Advanced FolderFolding Points: 86637 Folding Title: Advanced FolderFolding Points: 86637 Folding Title: Advanced FolderFolding Points: 86637 Folding Title: Advanced FolderFolding Points: 86637 Folding Title: Advanced Folder
Time spent in forums: 3 Months 1 Week 9 h 9 m 50 sec
Reputation Power: 1580
See here: 80040E14 errors

Scroll about half-way down for the explanation.

Basically, ADO/JET can't call a function in an Access database.
__________________
jmurrayhead

Did I help you out? Make me popular by clicking the icon!

New Members:Proper way to post a question

Powered by ASP.Net

Reply With Quote
  #6  
Old July 2nd, 2008, 11:52 AM
sweetorangepie's Avatar
sweetorangepie sweetorangepie is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Oct 2007
Posts: 141 sweetorangepie User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 14 h 3 m 37 sec
Reputation Power: 2
Thanks for that, do you have any suggestions as to what I could do to get around it?

Reply With Quote
  #7  
Old July 2nd, 2008, 11:55 AM
jmurrayhead jmurrayhead is offline
Moderator
ASP Free God 17th Plane (13000 - 13499 posts)
 
Join Date: Feb 2004
Location: Reston, VA, USA
Posts: 13,091 jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)  Folding Points: 86637 Folding Title: Advanced FolderFolding Points: 86637 Folding Title: Advanced FolderFolding Points: 86637 Folding Title: Advanced FolderFolding Points: 86637 Folding Title: Advanced FolderFolding Points: 86637 Folding Title: Advanced Folder
Time spent in forums: 3 Months 1 Week 9 h 9 m 50 sec
Reputation Power: 1580
What does this Salutation function do? You probably can duplicate it in either ASP or within your actual query.

Reply With Quote
  #8  
Old July 2nd, 2008, 11:58 AM
sweetorangepie's Avatar
sweetorangepie sweetorangepie is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Oct 2007
Posts: 141 sweetorangepie User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 14 h 3 m 37 sec
Reputation Power: 2
This is the code for the function:

Code:
Public Function Salutation(fld As String) As String     If InStr(1, fld, "Miss") > 0 Then         sal = "Miss"     ElseIf InStr(1, fld, "Mrs") > 0 Then         sal = "Mrs"     ElseIf InStr(1, fld, "Mr") > 0 Then         sal = "Mr"     ElseIf InStr(1, fld, "Ms") > 0 Then         sal = "Ms"     Else         sal = ""     End If     Salutation = sal End Function 


It is called by this >> Salutation: Salutation([FirstName]) which is a field in the query.

Basicly it looks at the firstname field and if it has mr miss mrs or ms in it then it places it in a field called salutation. I couldnt find anyother way of doing it other then using alot of nested iif's as an expression which i wasn't really sure how to do.

Reply With Quote
  #9  
Old July 2nd, 2008, 12:05 PM
jmurrayhead jmurrayhead is offline
Moderator
ASP Free God 17th Plane (13000 - 13499 posts)
 
Join Date: Feb 2004
Location: Reston, VA, USA
Posts: 13,091 jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)jmurrayhead User rank is General 9th Grade (Above 100000 Reputation Level)  Folding Points: 86637 Folding Title: Advanced FolderFolding Points: 86637 Folding Title: Advanced FolderFolding Points: 86637 Folding Title: Advanced FolderFolding Points: 86637 Folding Title: Advanced FolderFolding Points: 86637 Folding Title: Advanced Folder
Time spent in forums: 3 Months 1 Week 9 h 9 m 50 sec
Reputation Power: 1580
You're placing it in a field on the ASP page or in a field in the database? Explain your logic a little, this most likely can be done through ASP.

Reply With Quote
  #10  
Old July 2nd, 2008, 12:23 PM
sweetorangepie's Avatar
sweetorangepie sweetorangepie is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Oct 2007
Posts: 141 sweetorangepie User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 14 h 3 m 37 sec
Reputation Power: 2
Basicly I have a mailing list function that I used on another project that I want to re-use on another but the database design is diffrent. So what i'm doing is making a query which will take the data in my table and change it to look like the table which the mailing list functon query's will understand, naming the query the same as the table the sql will be looking for. I've got it all working apart from the salutation field which is what i'm using the module for. In the table for the first database there is a name field where as the mailing list functions need a salutation first name and last name field. In the query i have used expressions to seperate the first and last names but I couldnt figure out how to write an expression to sort out my salutation field problem so had to use a function. Is there anyway I could sort out the salutation problem with asp, if not then does anyone know how to write an expression to replace the function?

Thanks

Reply With Quote
Reply

Viewing: ASP Free ForumsProgrammingASP Development > Database - General - 80040e14 Error


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway
Stay green...Green IT