Access :: Can Include VB Function In Query
Apr 19, 2010
I have an access MDB database of latitude and longitude coordinates (x,y). I also have a function in VB similar to:
Public Function Distance (x1,y1,x2,y2) as Double
'Some code here
Distance = 'distance between x1,y1 and x2,y2
End Function
What I want to do is create a query that will show all locations contained in the table that are within 10 miles of user unetered coordinates (where LAT and LON are columns in the table and VarX and VarY are user proivided: SELECT *, Distance([LAT],[LON],VarX,VarY) as Dist FROM TableName WHERE Dist < 10
Obviously this doesn't work but I want to know how to accomplish this end result. Basically, I want to return a query of all locations within 10 miles of VarX and VarY. How do I incororate the Distance function into my query?
If it's not possible, what is the best workaround to accomplish this?
Using ASP.NET Visual Basic and a MS Access MDB
View 2 Replies
Similar Messages:
Jan 18, 2010
ASP.NET 3.5, IIS7,In my Global.asax's Application_BeginRequest, I need to extract from the request's URL an entirely seperate URL that's been embedded in it without using query string.
The solution I came up with was to hex-encode the entire target URL as if it were a directory, as follows:
http://localhost/687474703A...etc...732E6D7033/irrelevantFilename.txt
This fails for IIS7, whose ASP.NET implementation won't tolerate a URL path greater than 260 characters.My code controls how the request URL gets generated, and how it might embed the target URL in there, but it doesn't have any control over that target URL value (they're third-party URLs).How better could I embed this target URL in my request URL?
View 1 Replies
May 12, 2010
I'm using a pager and want to include a query string in some cases, like search to have a search parameter in the query string. Everything works fine with the pager. So, I tried the following line of code in my controller action for including search:
[Code]....
View 2 Replies
Dec 24, 2010
I have the following LINQ query inside my models/article class, but i am facing problem in add the current user id in the where statment, as i need to only display the artciles created by the login user, i tried using ; embership.GetUser().ProviderUserKey & ToInt32(Membership.GetUser().ProviderUserKey) , but all failed, either becuase the error indicates that i can not inheret the Memebership class , or because i can not convert object to integer:-
return from userarticle in db.Articles
// where userarticle.User_ID = ToInt32(Membership.GetUser().ProviderUserKey)
orderby userarticle.create_date
select userarticle;
so how i can do so , in other words what should i write after the where "userarticle.User_ID =" ?????? . Hint i am using the default login mechanisim provided by the MVC.
View 6 Replies
Jun 22, 2010
I have an application that I am developing using ASP.Net with visual basic code. I have a table called "Customers" that contains 3 fields. The name of each field is "Name", "LocationA", and "LocationB". I want to code a select query that list two columns. The first column should contain the field "Name". I want the second column to contain the value in the field "LocationB" if "LocationB" is not null, else I want the second column to contain the value in the field "LocationA".
View 4 Replies
Jan 21, 2011
Trying to use a dropdownlist to query a database so that it will return all values except 1 (or more in future versions).
For example, assume you had a simple table name "MYFRIENDS" which has two fields named "GROUP" and "NAME" with the following records:
Group
Name
A
John
B
Jane
C
Tony
D
Sue
What I want to do is create a DropDownList that has only 2 list items related to the "GROUP" field. The first list item should return records from the database related to Group A only. Then, the second list item should return all other records EXCLUDING those belonging to Group A.
The drop down list should look something like this (I've put a question mark where I don't know what to do):
[Code]....
After the selection is chosen in the above drop down list, it should query the database and return the desired result. I'm using an AccessDataSource with select parameters. Here's a sample of what that looks like:
[Code]....
Things I've tried that didn't work:
I tried using "Not A" as the the 2nd list item's value. I was thinking p1 would be replaced with the value "Not A" and the query would read "WHERE GROUP LIKE Not A". But, the query syntax "Like Not" is technically wrong. I tried changing the Where Clause to "WHERE GROUP p1" and then replaced the list item's value to "LIKE A" and the second to "NOT LIKE A". Again, I was thinking p1 would be replaced to read "WHERE GROUP LIKE A" and "WHERE GROUP NOT LIKE A". I also tried changing the "SelectCommand" itself so that after the dropdownlist changed, it would first change the selectcommand first and then run the query.
Why the first 2 items didn't work became somewhat obvious to me after thinking about it for a little while. However, I would think the 3rd one would/should work... as long as you have the sequence of events correct which up to this point I haven't been able to figure out.
View 3 Replies
Jan 6, 2010
I have a parent repeater that lists the sections of the website. this repeater binds to display a table that contain another repeater of the website pages .. or may display a table that contains another two repeaters of the projects categories and sub-categories.Until now everything is going fine.
The problem comes when I try to include a query of the section ID to the link of the project categories (DataView of the projects repeaters does not contain SectionID)my question is : is there any way to call the SectionID of the first repeater in my projects categories and sub-categories repeaters?Here is my code:
[Code]....
the code behind is as follow:
[Code]....
View 8 Replies
Aug 19, 2010
I want to use sum function in access database (not MS SQL) to add array of items in a particular date.For Eg. The Access Database format like
Date
Prod. Name
Value
[code]...
View 4 Replies
Jan 21, 2010
why I get the following error: Query input must contain at least one table or query
for this code...
Insert into BlogPost (BlogID,BlogTitle,BlogContent,Attatchments,IsEnabled,IsVisible) values
((SELECT BLOGID FROM Blog WHERE BlogOwnerID =7),'test','aaaaa','aaaa',true,true);
all i know that it is a problem with how i have nested the select statement...
View 1 Replies
Mar 25, 2010
Can a query output made in MS ACCESS be accessed as a database in Visual Studio 2008?
I have a Parent and Child Table in MS Access with a one-to-many relationship. I created a query in Access that would produce a result table and I want the contents of this Query to be displayed in a Data Grid in Visual Studio 2008.
View 11 Replies
Jun 7, 2010
i am new to asp.net programming i am trying to connect asp.net web application with ms access 2007 database. i have taken with two text boxes and when i enter some data in it and press submit button the data must load in access db i created with same fields.
my code is :
[code]....
Syntax error in string in query expression what is the correct way of inserting data into access db and what is the Syntax error in string in query expression.
View 3 Replies
Jun 9, 2010
I have a data type mismatch while inserting into a number field in an access database using a parameterized query.I think this should be pretty simple but I am still learning a lot.
[Code]....
I have some commented out as I am working one field at a time. The working fields are textboxes and the non working ones are dropdown lists. But I think it may be the field that the list is drawing from? Not sure.
View 2 Replies
Feb 21, 2011
I'm writing a web service that needs to query an Access 2003 database (.mdb). I've found the following code in doing some research on OLEDB connections and queries:
[Code]....
Errors are as follows:
Error 3 A field initializer cannot reference the non-static field, method, or property 'CompleteRentalls.completedb.sqlString'
Error 5 'CompleteRentalls.completedb.da' is a 'field' but is used like a 'type'
Can anyone help me rectify the above code such that the query results are returned to my datatable?
View 4 Replies
Apr 4, 2010
I executed the following sql command, and got error "Operation must use an updateable query.".
[Code]....
The database is access 2003. The tables are T1 (code (key), n) and T2 (code(key),num). Why do I get this error and how do I solve it? EDIT: Found solution somewhere else.
View 3 Replies
May 20, 2013
I have just started with ASP.NET.
I like the idea of using Include files so that I can create various versions of individual parts of a site and decide in code which to display. I used:
<%Response.WriteFile("contentcontent.aspx")%>
to include a content.aspx file within my default.aspx page.
I would like to include a Left.aspx, Main.aspx and Right.aspx file inside the content.aspx file. I tried using the reponse.writefile function but noticed when I debug the website that the text "reponse.writefile..." displays instead of the code contained within the referenced file(s).
Can this not be done?
View 6 Replies
Mar 18, 2010
i have a function which returns a value from a query string parameter, i use it in more than 10 places in the webapp thus i have to rewrite the code every time, again and again.so to make it short, is there any way i can embed the code somewhere and keep referring to it through out my app?
View 10 Replies
Nov 19, 2010
I have a number of automatically generated data access classes to handle things like inserts & updates. These look like:
cmd.CommandType = CommandType.Text
cmd.CommandText = "UPDATE myTable set f1 = :f1, f2 = :f2, f3 = :f3 where id = :id"
cmd.Parameters.AddWithValue(":f1", _f1)
cmd.Parameters.AddWithValue(":f2", _f2)
cmd.Parameters.AddWithValue(":f3", _f3)
cmd.ExecuteNonQuery()
If I were to re-write the sql to do what I want, it would look something like
cmd.CommandText = "UPDATE myTable set f1 = pkg.getMyValue, f2 = :f2, f3 = :f3 where id = :id"
Is there any way to do this by setting _f1 to a "special" value, without changing the update SQL or the way the parameters are set? Only in certain cases will I need to set the value of f1 - most of the time, it will be null.
Using .net 2.0, and system.data.oracleclient against oracle 11.
View 1 Replies
Apr 8, 2010
I have a problem here.In my database I store member status in 1 and 0, when it come to my gridview I need change 1 and 0 to active and inactive. My company is using Linq, so I must follow. I wrote in this style, I calling a changeToWord() function to change 1 and 0 to active and inactive.
var q=from a in db.members
select new{
mem_name=a.name,
status=ChangeToWords(a.status)
}
It compiles with no error, but when I execute the page, it prompt out a error message to me.
View 3 Replies
Sep 7, 2010
I've come to a roadblock in my app and I'm not sure which way I should go. Currently, I have a slider control and two text boxes used to set the Start and End times of a section of a video. Let's say the video is of some Music Awards. In my database, I've tagged the start and end time of each celebrities on-screen appearance. When the user adjusts their start and end times on the page, I want to query the database table and pull back all celebrities within that range. The problem is I don't know how to do this in JS.
Can I use the Check Box List and bind the values to it? Do I need to render a table of Check Boxes in JavaScript? Do I call the Server-Side code via Ajax and then partially render the page?
View 1 Replies
Dec 6, 2010
i am developing a webaaplication ASP.net using C# and MYSQL as backend..
i am facing problem to execute this query in MYSQL:
SELECT ID, Date, Event, Remark, school, section, class, schooltype, shift
FROM sessioncalendar
WHERE (school = 'SECONDARY SCHOOL') AND (class = 'IX') AND (section = 'B') AND (shift = 'SHIFT I') AND (schooltype = 'XYZ School')
AND MONTH ( Date )= '6'
AS the query works well wethout addind AND MONTH ( Date )= '6' ... but when i add this line query generate error
( Error in list of function arguments: ')' not recognized. Unable to parse query text.)
While same query is working successfully with Sql Server 2005...but i hvnt found any reason why my query is not working with Date(datetime) column..i hv google about it..but i found synatax is same in both SQL SErver 2005 and MY SQL syntax
View 1 Replies
Feb 9, 2011
I have many record in my sql table and i want to fetch last row of table.I have used max function but it is very slow
i m using this query-
select pm_name from datos where date_time = (select Max(date_time) from datos) but it takes more time i want to use select count(date_time) from datos this query provide me row number then how can fetch row of this number.
View 11 Replies
Apr 6, 2010
I have an update statement here:
id is a long auto-increment integer.
UPDATE [table1] SET [icon] = Str([id]) & @file_ext where
id=@id;
after I execute this statement, there is a space in my access, such as " 1.jpg"
So I decide to hard-code the id:
UPDATE [table1] SET [icon] = '1' & @file_ext where id=@id;
It's work! the result is "1.jpg"
Is there sth wrong in my code? Thx!
View 4 Replies
Jun 1, 2010
I have a function called Public Shared Function get_userDB() As String in my MastePage.master.vb file that i would like to access from my users page that is connected to the master page.
I have tried with: me.master.get_userDB()
But that won't work. It says that my function is not a member of my masterpage. What im i doing wrong?
View 4 Replies
Oct 25, 2010
I want to set ASP.net custom validator error parameter text through client side javascript. How can access it via sender, args parameters in my function?
View 1 Replies
Apr 15, 2010
I am trying to create a chat application like Facebook
My chat windows are in the footer control of the website, and C# code also in footer's CS file, i need to call C# function from footer CS file into javascript included in my footer.aspx file,
i have tried it by ICallbackEventHandler, but WebForm_DoCallback(this,arg,RecieveMessage,"",null,false); simply postback my current page, but i need to postback footer.aspx only and call "public void RaiseCallbackEvent(String eventArgument)".
View 3 Replies
