MVC :: Get Query String Value?


When Logging in I need to get the Return Url which is as a parameter on the url.I am using Asp.Net Memeberhip ... On my custom model binder I have the following: AccountLogin account = new AccountLogin { Password = (String)binding.ValueProvider["Password"].ConvertTo(typeof(String)), RememberMe = (Boolean)binding.ValueProvider["RememberMe"].ConvertTo(typeof(Boolean)), [code].... I get the error:The name 'Request' does not exist in the current context C:UsersMiguelProjectsStdSolutionStdBindersAccountLoginBinder.cs What is the correct way to get the value of the ReturnUrl?

View Answers
Very similar questions


Strings From Lookups www.xtremevbtalk.com

This is kinda newbie question, since I'm a relative newbie at this:I have an access database with a query table that gets its values from several lookup tables. When I look at this table from within access, I see the strings of the lookups. When I query this table using ADO I get the numeric values of those lookups, not the strings.Is there any way to have access store the real string values it gets from a lookup? or do I have to change my query to retrieve every single string from each lookup...

Get Value Of A Query String From Asp.net Mvc Controller Action To <script Type="text/javascript"> stackoverflow.com

I am passing a query string with name "RowTobeHighLighted" from my Asp.net mvc action result. What I have to do is, I have to get the query string value from that controller action to a script of type text/javascript. I have tried to use simple Request.Querystring() under javascript. But that is not working. Is it possible to get the querystring value from controller action.Or, is it possible to get the value of viewdata under tag.

MVC :: Route Debugger By Stephen Walther? forums.asp.net

I'm trying to follow Stephen Walther's MVC tip: Build a Controller to Debug Your Custom Routes (http://stephenwalther.com/blog/archive/2008/08/03/asp-net-mvc-tip-29-build-a-controller-to-debug-your-custom-routes.aspx) but I'm getting this error "Object reference not set to an instance of an object." when getting the values of the RouteTable. Function Index() As ActionResult Dim context As HttpContextBase = Me.ControllerContext.HttpContext Dim sb As New StringBuilder For Each namedRoute As Route In RouteTable.Routes'Dim dataTokens = formatValues(namedRoute.Defaults) 'this looks good Dim rd = namedRoute.GetRouteData(context)'sb.Append(dataTokens & "<br>") 'this looks good sb.Append(formatValues(rd.Values)) 'this one is not, error here [:(] Next End Function Private Function formatValues(ByVal values As RouteValueDictionary) As String If values Is Nothing Then Return "N/A" End If Dim col = New List(Of [String])() For Each key As String In values.Keys Dim value As Object = If(values(key), Nothing) col.Add((key & "=") + value.ToString()) Next Return String.Join(", ", col.ToArray()) End Function You have to reference the debugger file (RouteDebugger.dll) provided by Stephen. I'm trying to get the Route Name's for each controller.

Upgrade To MVC 2.0 Model Binding ? forums.asp.net

I have just upgraded to MVC 2.0 and I have noticed a difference in the model binding when posting a form back to an action. In MVC 1.0 if I had a posted a blank form back to my action and then looked at the populated model class my empty string values would show as empty strings, in MVC 2.0 doing the same thing and then looking at my model class shows my empty string values as null, why has this changed?

MVC :: Bind Static Html Controls? forums.asp.net

How do you bind static html controls on MVC? This MVC textbox helper can bind values on return <% =Html.TextBox("firstname", Html.Encode(item.FirstName), New With {.class = "txtClass"})%> but not on a static textbox. <input id="firstname" name="firstname" type="text" value="Joe" /> Public Class Personal Private _FirstName As String Public Property FirstName() As String Get Return _FirstName End Get Set(ByVal value As String) _FirstName = value End Set End Property End Class <AcceptVerbs(HttpVerbs.Post)> _ Public Function Index(ByVal member As Personal) As ActionResult Return View() End Function

MVC :: Preserving Query String Values When Redirecting? forums.asp.net

What is the best way to preserve the current url query string when redirecting in MVC? My query string has ws-federation keys in it that I need to preserve when redirecting to my login page. Originally I did the following but for some reason MVC did not url encode the ampersands separating the keys so the ws-federation stuff has issues down stream: RouteValueDictionary dict = new RouteValueDictionary();

ErrorMessageResourceName And ErrorMessage Can't Set Both stackoverflow.com

This is the error I'm getting using MVC2: Either ErrorMessageString or ErrorMessageResourceName must be set, but not both. It is coming from the [Required] Validation DataAnnotation. Stack trace: InvalidOperationException: Either ErrorMessageString or ErrorMessageResourceName must be set, but not both.] System.ComponentModel.DataAnnotations.ValidationAttribute.SetupResourceAccessor() +89338 System.ComponentModel.DataAnnotations.ValidationAttribute.FormatErrorMessage(String name) +38 System.Web.Mvc.<Validate>d__1.MoveNext() +215 System.Web.Mvc.<Validate>d__5.MoveNext() +735 System.Web.Mvc.DefaultModelBinder.OnModelUpdated(ControllerContext controllerContext, ModelBindingContext bindingContext) +424 System.Web.Mvc.DefaultModelBinder.BindComplexModel(ControllerContext controllerContext, ModelBindingContext bindingContext) +732 System.Web.Mvc.ControllerActionInvoker.GetParameterValue(ControllerContext controllerContext, ParameterDescriptor parameterDescriptor) +475 System.Web.Mvc.ControllerActionInvoker.GetParameterValues(ControllerContext controllerContext, ActionDescriptor actionDescriptor) +152 System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName) +709 System.Web.Mvc.Controller.ExecuteCore() +162 System.Web.Mvc.<>c__DisplayClass8.<BeginProcessRequest>b__4() +58 System.Web.Mvc.Async.<>c__DisplayClass1.<MakeVoidDelegate>b__0() +20 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +453 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +371 I've boiled my view model down to this(it breaks any time there is a [Required] attribute, works fine without): [Required(ErrorMessage = "")] [DataType(DataType.Text)] [DisplayName("Property Name")] public string MyProperty { get; set; } My controller returns an empty ViewModel, and the form in the view is completely blank...just a submit button.

MVC :: Generic List With Default Value As Method Parameter? forums.asp.net

In one of the methods I'm using in my MVC app, there's a param that accepts a list collection of strings. If I have a string parameter, I can give it a default value of an empty string, but I cannot seem to give the list collection a default value of a new, empty list collection. I get the error that's beginning to seriously grate on my nerves about requiring a compile-time constant. getting the generic list to work with a default empty set?

ASP.NET MVC - Store A String Per User, So It Seems Like A Violation To The MVC Separation? stackoverflow.com

I have a question about static strings and so forth, in an ASP.NET MVC.I need to hold a string(a value), when the user goes through the application.Problem is, I feel like that would be a violation to the MVC. I just need to store a string per user, so it seems like a violation to the MVC separation.

SQL Query String Not Working social.msdn.microsoft.com

I have a SQL query string that gets the top 5 records from a database however 3 variables are passed with the sql query that gets specific data.[code]


MVC :: Error "CS1928: 'System.Web.Mvc.HtmlHelper<DataLayer.BlogPost>' Does Not Contain A Definition For... forums.asp.net

I'm using a html helper that i got from here: [URL] here is my modified version (using SelectListItem): public static string CheckBoxList(this HtmlHelper htmlHelper, string name, List<SelectListItem> listInfo) { return htmlHelper.CheckBoxList(name, listInfo, ((IDictionary<string, object>)null)); } public static string CheckBoxList(this HtmlHelper htmlHelper, string name, List<SelectListItem> listInfo, object htmlAttributes) { return htmlHelper.CheckBoxList(name, listInfo, ((IDictionary<string, object>)new RouteValueDictionary(htmlAttributes))); } public static string CheckBoxList(this HtmlHelper htmlHelper, string name, List<SelectListItem> listInfo, IDictionary<string, object> htmlAttributes) { if (String.IsNullOrEmpty(name)) throw new ArgumentException("The argument must have a value", "name"); if (listInfo == null) throw new ArgumentNullException("listInfo"); if (listInfo.Count < 1) throw new ArgumentException("The list must contain at least one value", "listInfo"); StringBuilder sb = new StringBuilder();................ I can't seem to figure out why this always throws an error: CS1928: 'System.Web.Mvc.HtmlHelper<DataLayer.BlogPost>' does not contain a definition for 'CheckBoxList' and the best extension method overload 'HtmlHelpers.HtmlHelpers.CheckBoxList(System.Web.Mvc.HtmlHelper, string, System.Collections.Generic.List<System.Web.Mvc.SelectListItem>)' has some invalid arguments

MVC :: Obtain Url Query String During Json Request? forums.asp.net

So I'm writing an MVC application, and have a JsonResult post back to obtain some item information for scanned items on a warehouse application I am writing. I'm trying to obtain a URL query string value though, and cannot seem to obtain one via the normal 'Request.QueryString['variable']' way... Is there a way to do this? I also thought about just passing the parameter into my post, but I already have a single value on my jquery post, and I am unsure if I can tack on more values to this.

MVC :: ValidateRequest Appears To Be Kicking In RC1 Despite Settings? forums.asp.net

After upgrading a project to the RC a System.Web.HttpRequestValidationException is thrown when posting a value containing HTML from a TextArea. I have checked that validateRequest=false in Views/web.config, and have set this in the application's root web.config. I have also created a fresh MVC project, created a simple view & controller and posted a simple html paragraph element with the same result. Call stack provided. [HttpRequestValidationException (0x80004005): A potentially dangerous Request.Form value was detected from the client (html="hello world ").] System.Web.HttpRequest.ValidateString(String s, String valueName, String collectionName) +8718538 System.Web.HttpRequest.ValidateNameValueCollection(NameValueCollection nvc, String collectionName) +111 System.Web.HttpRequest.get_Form() +129 System.Web.HttpRequestWrapper.get_Form() +11 System.Web.Mvc.ValueProviderDictionary.PopulateDictionary() +113 System.Web.Mvc.ValueProviderDictionary..ctor(ControllerContext controllerContext) +74 System.Web.Mvc.ControllerBase.get_ValueProvider() +31 System.Web.Mvc.ControllerActionInvoker.GetParameterValue(ControllerContext controllerContext, ParameterDescriptor parameterDescriptor) +53 System.Web.Mvc.ControllerActionInvoker.GetParameterValues(ControllerContext controllerContext, ActionDescriptor actionDescriptor) +109 System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName) +350 System.Web.Mvc.Controller.ExecuteCore() +110 System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext) +27 System.Web.Mvc.ControllerBase.System.Web.Mvc.IController.Execute(RequestContext requestContext) +7 System.Web.Mvc.MvcHandler.ProcessRequest(HttpContextBase httpContext) +119 System.Web.Mvc.MvcHandler.ProcessRequest(HttpContext httpContext) +41 System.Web.Mvc.MvcHandler.System.Web.IHttpHandler.ProcessRequest(HttpContext httpContext) +7 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +181 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75

MVC :: Finding Books And Links For Mvc And Learning Linq Queries forums.asp.net

i want to get masterized....in MVC finding books and links for mvc..and learning linq queries

MVC :: Silverlight App Error On Production Machine? forums.asp.net

i get the below error when i run the site on our production, the silverlight apps are in a .ascx view. [ArgumentException: The virtual path '/Views/Home/DailyProductionGuages.ascx' maps to another application, which is not allowed.] System.Web.VirtualPath.FailIfNotWithinAppRoot() +11363277 System.Web.Compilation.BuildManager.ValidateVirtualPathInternal(VirtualPath virtualPath, Boolean allowCrossApp, Boolean codeFile) +271 System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) +155 System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) +116 System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean noAssert) +175 System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp, Boolean noAssert) +52 System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(String virtualPath, Type requiredBaseType) +44 System.Web.Mvc.BuildManagerWrapper.System.Web.Mvc.IBuildManager.CreateInstanceFromVirtualPath(String virtualPath, Type requiredBaseType) +48 System.Web.Mvc.WebFormViewEngine.FileExists(ControllerContext controllerContext, String virtualPath) +110 System.Web.Mvc.VirtualPathProviderViewEngine.GetPathFromSpecificName(ControllerContext controllerContext, String name, String cacheKey, String[]& searchedLocations) +45 System.Web.Mvc.VirtualPathProviderViewEngine.GetPath(ControllerContext controllerContext, String[] locations, String[] areaLocations, String locationsPropertyName, String name, String controllerName, String cacheKeyPrefix, Boolean useCache, String[]& searchedLocations) +353 System.Web.Mvc.VirtualPathProviderViewEngine.FindPartialView(ControllerContext controllerContext, String partialViewName, Boolean useCache) +213 System.Web.Mvc.<>c__DisplayClass2.<FindPartialView>b__1(IViewEngine e) +40 System.Web.Mvc.ViewEngineCollection.Find(Func`2 cacheLocator, Func`2 locator) +324 System.Web.Mvc.HtmlHelper.FindPartialView(ViewContext viewContext, String partialViewName, ViewEngineCollection viewEngineCollection) +42 System.Web.Mvc.HtmlHelper.RenderPartialInternal(String partialViewName, ViewDataDictionary viewData, Object model, TextWriter writer, ViewEngineCollection viewEngineCollection) +342 System.Web.Mvc.Html.RenderPartialExtensions.RenderPartial(HtmlHelper htmlHelper, String partialViewName) +99 ASP.views_home_dailyproductionhourlylist_ascx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) +8988 System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +115 System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +240 System.Web.UI.Page.Render(HtmlTextWriter writer) +38 System.Web.Mvc.ViewPage.Render(HtmlTextWriter writer) +94 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4240

Regex :: Exclude A String Anyhwere In Pattern From Matches? stackoverflow.com

I need to write a regex which will match URLs that do not have a specific query string name/value pair anywhere in its URL. All other query string names, and all other query string values with the same name should be matched. Other pages in the same directory (or sub-directories) should not be matched.URL...The query string name and value that I need to exclude from matches is:[code]How can I prevent matches when the string exists anywhere in the pattern?

Mono With SQL Server Membership Provider? stackoverflow.com

Apparently Mono replaces references to SQL Server membership provider with sqlite membership provider (see ASP.NET_Settings_Mapping). Is there any way to convince Mono to use SQL Server for the membership provider? When I try to log in to my web app, I get the following: System.Configuration.Provider.ProviderException: Operation aborted due to an exception (see Trace for details). at System.Web.Security.SqliteMembershipProvider.ValidateUser (string,string) <0x003bb> at DirectMail.Controllers.AccountMembershipService.ValidateUser (string,string) [0x00000] in [file].cs:404 at DirectMail.Controllers.AccountController.ValidateLogOn (string,string) [0x00040] in [file].cs:346 at DirectMail.Controllers.AccountController.LogOn (string,string,bool,string) [0x00000] in [file].cs:79 at (wrapper dynamic-method) System.Runtime.CompilerServices.ExecutionScope.lambda_method (System.Runtime.CompilerServices.ExecutionScope,System.Web.Mvc.ControllerBase,object[]) <0x001c1> at System.Web.Mvc.ActionMethodDispatcher.Execute (System.Web.Mvc.ControllerBase,object[]) <0x00028> at System.Web.Mvc.ReflectedActionDescriptor.Execute (System.Web.Mvc.ControllerContext,System.Collections.Generic.IDictionary`2<string, object>) <0x0015b> at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod (System.Web.Mvc.ControllerContext,System.Web.Mvc.ActionDescriptor,System.Collections.Generic.IDictionary`2<string, object>) <0x00036> at System.Web.Mvc.ControllerActionInvoker/<InvokeActionMethodWithFilters>c__AnonStoreyB.<>m__E () <0x00092> at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter (System.Web.Mvc.IActionFilter,System.Web.Mvc.ActionExecutingContext,System.Func`1<System.Web.Mvc.ActionExecutedContext>) <0x00125> The top of the file /usr/local/etc/mono/4.0/settings.map on one Debian Linux machine is: <?xml version="1.0" encoding="utf-8" ?> <settingsMap> <map sectionType="System.Web.Configuration.MembershipSection, System.Web, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" mapperType="Mono.Web.Util.MembershipSectionMapper, Mono.Web, Version=, Culture=neutral, PublicKeyToken=0738eb9f132ed756" platform="Unix">.......

Accessing REG_SZ And REG_MULTI_SZ Type Data From Registry www.codeguru.com

HiI am using RegOpenKeyEx and RegQueryValueEx functions of advapi32.dll to get values of some keys from registry.The data are of REG_SZ and REG_MULTI_SZ type.Say for example ,i am trying to get the value of "Java Runtime" under the Key "HKEY_CURRENT_USERSoftwareJavaSoftJava Plug-in" in the registry.The value stored in "Java Runtime" is "Default"My calls to RegOpenKeyEx and RegQueryValueEx are as followsDim lngKeyHandle As LongDim lngResult As LongDim regSZdata As StringDim lngSZsize As LonglngResult = RegOpenKeyEx(HKEY_CURRENT_USER, "SoftwareJavaSoftJava Plug-in", 0&, KEY_READ, lngKeyHandle)MsgBox "result after opening " & lngResult 'display line 1MsgBox "handle after opening " & lngKeyHandle 'display line 2lngResult = RegQueryValueEx(lngKeyHandle, "Java Runtime", 0&, REG_SZ, ByVal regSZdata, lngSZsize)Msgbox "result after Query " & lngResult 'display line 3MsgBox "size after query " & lngSZsize 'display line 4MsgBox "data " & regSZdata display line 5I am getting the value of 0 (i.e. ERROR_SUCCESS) for lngResult in RegOpenEx and I am getting the handle to that registry key.(display line 1 & 2)I am getting the following values after the above call to RegQueryValueExValue of lngResult - 0 (display line 3)value of lngSZsize - 8 (display line 4) - this is the length of "Default" with null appendedValue of regSZdata - "" (display line 5) an empty string with length 01) Why I am not getting the value of the registry key in regSZdata -I am getting the size of data correctly but I could not get the value of data.2)How to get values of REG_MULTI_SZ from the registry .I used the following code.but I am facing the same problem as above.Dim lngKeyHandle As LongDim lngResult As LongDim regSZdata As StringDim lngSZsize As LonglngResult = RegOpenKeyEx(HKEY_CURRENT_USER, "SoftwareRational SoftwareRational AdministratorProject List", 0&, KEY_READ, lngKeyHandle)MsgBox "result after opening " & lngResult 'display line 1MsgBox "handle after opening " & lngKeyHandle 'display line 2lngResult = RegQueryValueEx(lngKeyHandle, "Data List", 0&, REG_MULTI_SZ, ByVal regSZdata, lngSZsize)Msgbox "result after Query " & lngResult 'display line 3MsgBox "size after query " & lngSZsize 'display line 4MsgBox "data " & regSZdata display line 5I am declaring regSZdata as String for retrieving REG_MULTI_SZ type data .Is it correct or I have to use string array .Here also I am getting some count for lngSZSize ,but i couldn't get the value.I have declared all the needed functions and constants from the above API as private in my code.My full code is as follows---------------------------private Declare Function RegCloseKey Lib "advapi32.dll" (ByVal hKey As Long) As LongPrivate Declare Function RegEnumKey Lib "advapi32.dll" Alias "RegEnumKeyA" (ByVal hKey As Long, ByVal dwIndex As Long, ByVal lpName As String, ByVal cbName As Long) As LongPrivate Declare Function RegOpenKey Lib "advapi32.dll" Alias "RegOpenKeyA" (ByVal hKey As Long, ByVal lpSubKey As String, phkResult As Long) As LongPrivate Declare Function RegOpenKeyEx Lib "advapi32.dll" Alias "RegOpenKeyExA" (ByVal hKey As Long, ByVal lpSubKey As String, ByVal ulOptions As Long, ByVal samDesired As Long, phkResult As Long) As LongPrivate Declare Function RegQueryValue Lib "advapi32.dll" Alias "RegQueryValueA" (ByVal hKey As Long, ByVal lpSubKey As String, ByVal lpValue As String, lpcbValue As Long) As LongPrivate Declare Function RegQueryValueEx Lib "advapi32.dll" Alias "RegQueryValueExA" (ByVal hKey As Long, ByVal lpValueName As String, ByVal lpReserved As Long, lpType As Long, lpData As Any, lpcbData As Long) As Long ' Note that if you declare the lpData parameter as String, you must pass it By Value.Private Const HKEY_CLASSES_ROOT = &H80000000Private Const HKEY_CURRENT_USER = &H80000001Private Const HKEY_LOCAL_MACHINE = &H80000002Private Const HKEY_USERS = &H80000003Private Const ERROR_SUCCESS = 0&Private Const SYNCHRONIZE = &H100000Private Const READ_CONTROL = &H20000Private Const STANDARD_RIGHTS_READ = (READ_CONTROL)Private Const STANDARD_RIGHTS_REQUIRED = &HF0000Private Const STANDARD_RIGHTS_WRITE = (READ_CONTROL)Private Const STANDARD_RIGHTS_EXECUTE = (READ_CONTROL)Private Const STANDARD_RIGHTS_ALL = &H1F0000Private Const KEY_QUERY_VALUE = &H1Private Const KEY_CREATE_SUB_KEY = &H4Private Const KEY_SET_VALUE = &H2Private Const KEY_ENUMERATE_SUB_KEYS = &H8Private Const KEY_NOTIFY = &H10Private Const KEY_CREATE_LINK = &H20Private Const KEY_READ = ((STANDARD_RIGHTS_READ Or KEY_QUERY_VALUE Or KEY_ENUMERATE_SUB_KEYS Or KEY_NOTIFY) And (Not SYNCHRONIZE))Private Const REG_DWORD = 4 ' 32-bit numberPrivate Const REG_MULTI_SZ = 7 ' Multiple Unicode stringsPrivate Const REG_BINARY = 3 ' Free form binaryPrivate Const REG_SZ = 1 ' Unicode nul terminated stringDim lngKeyHandle As LongDim lngResult As LongDim regSZdata As StringDim lngSZsize As LongSub Form_Load()'Registry.GetKeyValue HKEY_LOCAL_MACHINE, "SOFTWAREJavaSoftJava Development Kit1.2", "JavaHome", sdata 'workinglngResult = RegOpenKeyEx(HKEY_CURRENT_USER, "SoftwareJavaSoftJava Plug-in", 0&, KEY_READ, lngKeyHandle)MsgBox "result after opening " & lngResultMsgBox "handle after opening " & lngKeyHandlelngResult = RegQueryValueEx(lngKeyHandle, "Java Runtime", 0&, REG_SZ, ByVal regSZdata, lngSZsize)MsgBox "result after query " & lngResultMsgBox "handle after query" & lngKeyHandleMsgBox "size after query " & lngSZsizeMsgBox "data " & regSZdataResult = RegCloseKey(lngKeyHandle)End Sub-------------------------------------------------------------------------------Please Help me in solving thisThanks in advancewith regardsSivajothi

Python MySQLdb String Substitution Without Added Quotations? stackoverflow.com

I'd like to use string substitution for a comma-separated list, such as: query = """SELECT id, name, image_id FROM users WHERE id IN (%s) """ values = (','.join(uids)) results = dbc.getAll(query, values

Array Passed POST Method To Catch In ASP.NET MVC? stackoverflow.com

Can PHP array passed POST method to catch in ASP.NET MVC?Query string: WebAccess/ArrayTest?val[]=1&val[]=2&val[]=3I write: ActionResult ArrayTest (String[] val)But this only works if the query string to remove the "[]"

MVC :: How To Change Namespace System.Web.Mvc.ViewPage Namespace To System.Web.Mvc.ViewPage forums.asp.net

i doing one application.That is grid binding .i got this error System.Web.Mvc.HtmlHelper<object>' does not contain a definition for 'GridView' and the best extension method overload 'MvcApplication2.Code.GridViewExtensions.GridView<T>(System.Web.Mvc.HtmlHelper, MvcApplication2.Code.GridViewData<T>, System.Action<MvcApplication2.Code.GridViewData<T>>, System.Action<T,string>, string, string, System.Action<T>, System.Action<MvcApplication2.Code.GridViewData<T>>)' how to find this solution and how to change System.Web.Mvc.ViewPage to System.Web.Mvc.ViewPage<Model>

MVC :: Server Side Validation In 2? forums.asp.net

i am following validation code from this link..http://www.dotnetcurry.com/ShowArticle.aspx?ID=413&AspxAutoDetectCookieSupport=1so added dll's Microsoft.Web.Mvc.DataAnnotations, System.ComponentModel.DataAnnotations( i removed this dll and added again). now iam getting this error when iam click on login button.Server Error in '/' Application.Method not found: 'System.Collections.Generic.IDictionary`2<System.String,System.Web.Mvc.ValueProviderResult> System.Web.Mvc.ModelBindingContext.get_ValueProvider()'.

SQL Reporting :: Parameter Values Not Getting Filled? forums.asp.net

I have a report with a few parameters. One of the parameter is a multivalued parameter with string type values. Data is being filled into it from a dataset and also iam filling defalut values from the dataset using 'from query'. The report runs and all report parameters gets filled and parameter values gets selected by default. However, in another server, for the same report, the said multivalued parameter gets filled but the parameter values does not get selected by default.

MVC :: 2 P1 - This Exception Should Never Occur forums.asp.net

This exception should never occur In my view code is: <asp:Content ID="indexContent" ContentPlaceHolderID="MainContent" runat="server"> <% foreach (var cat in Model) { Html.DisplayFor(d => cat); } %> </asp:Content> I dont put any attribuites to my model and I dont create any EditorTemplates. What can i do with this? Stack trace: [InvalidOperationException: This exception should never occur.] System.Web.Mvc.Html.TemplateHelpers.TemplateHelper(HtmlHelper html, String expression, Type parentModelType, String propertyName, Type modelType, Object modelValue, String templateName, DataBoundControlMode mode) +241915 System.Web.Mvc.Html.DefaultDisplayTemplates.ObjectTemplate(HtmlHelper html) +563 System.Web.Mvc.Html.<>c__DisplayClass11.<.ctor>b__f(HtmlHelper html, ViewDataDictionary viewData) +140 System.Web.Mvc.Html.ActionCacheItem.Execute(HtmlHelper html, ViewDataDictionary viewData) +17 System.Web.Mvc.Html.TemplateHelpers.TemplateHelper(HtmlHelper html, String expression, Type parentModelType, String propertyName, Type modelType, Object modelValue, String templateName, DataBoundControlMode mode) +881 System.Web.Mvc.Html.DefaultDisplayTemplates.ObjectTemplate(HtmlHelper html) +563 System.Web.Mvc.Html.TemplateHelpers.TemplateHelper(HtmlHelper html, String expression, Type parentModelType, String propertyName, Type modelType, Object modelValue, String templateName, DataBoundControlMode mode) +1385 System.Web.Mvc.Html.TemplateHelpers.TemplateFor(HtmlHelper`1 html, Expression`1 expression, String templateName, String htmlFieldId, DataBoundControlMode mode) +194 System.Web.Mvc.Html.DisplayExtensions.DisplayFor(HtmlHelper`1 html, Expression`1 expression, String templateName, String htmlFieldId) +56 System.Web.Mvc.Html.DisplayExtensions.DisplayFor(HtmlHelper`1 html, Expression`1 expression) +50 ASP.views_home_index_aspx.__RenderindexContent(HtmlTextWriter __w, Control parameterContainer) in d:ProjectsCoreSourcesMvcApplication1ViewsHomeIndex.aspx:12 System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +256 System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +19 System.Web.UI.Control.Render(HtmlTextWriter writer) +10 System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +27 System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +99 System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +25 ASP.views_shared_site_master.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in d:ProjectsCoreSourcesMvcApplication1ViewsSharedSite.Master:26 System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +256 System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +19 System.Web.UI.Control.Render(HtmlTextWriter writer) +10 System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +27 System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +99 System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +25 System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +134 System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +19 System.Web.UI.Page.Render(HtmlTextWriter writer) +29 System.Web.Mvc.ViewPage.Render(HtmlTextWriter writer) +59 System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +27 System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +99 System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +25 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1266

Forms Data Controls :: DetailsView Insert Into Table And Query String? forums.asp.net

I am passing a query string into a new page and want a detailsview to insert whatever comments a user enters I am getting an error AlbumUID does not accept nulls error. I thought I passed the query string value to the insert statement but I must have missed something Here's what I have: <asp:SqlDataSource ID="SqlDSAddComment" runat="server" ConnectionString="<%$ ConnectionStrings:MyCDsConnectionStringHome %>" InsertCommand="INSERT INTO [Comments] ([Comments], [Rating], [AlbumUID]) VALUES (@Comments, @Rating, @AlbumUID)" [Code]....

Get Values From Encoded Query String? forums.devshed.com

I am using base64_encode & decode to pass encrypted query string values between pages. I am having trouble getting the values after I decrypt the query string. I am still fairly new to php, if it might not be obvious. I have tried these: Code: $qs = base64_decode($_SERVER["QUERY_STRING"]); $a = $qs[a]; or $a = $qs["a"];

What Should I Choose Webforms Or Mvc stackoverflow.com

Possible Duplicates: Advice on using ASP.net WebForms or MVC, How to decide which is right, WebForms or MVC when doing ASP.NET I am new to web development and asp.net... I was going through asp.net website and 'n' number of question here in stackoverflow regarding Webforms or MVC.... But still as a beginner can't get an idea what to choose? What should i choose webforms or mvc?If MVC,What should i know before getting started with it?If webforms,What should i know before getting started with it?

MVC :: How To Locate Source Of Error When UpdateModel Fails Within OnActionExecuting forums.asp.net

I am getting the following error when I call UpdateModel from within a controller's OnActionExecuting event. The error message is not very helpful. How can I determine what is really causing the problem. Message "The model of type 'UI.Models.CustomerViewModel' was not successfully updated." StackTrace " at System.Web.Mvc.Controller.UpdateModel[TModel](TModel model, String prefix, String[] includeProperties, String[] excludeProperties, IDictionary`2 valueProvider) at System.Web.Mvc.Controller.UpdateModel[TModel](TModel model) at UI.Controllers.CustomerController.OnActionExecuting(ActionExecutingContext filterContext) in C:\Documents and Settings\Mark\My Documents\Visual Studio 2008\Projects\PutTogether\UI\Controllers\CustomerController.cs:line 146" string TargetSite {Void UpdateModel[TModel](TModel, System.String, System.String[], System.String[], System.Collections.Generic.IDictionary`2[System.String,System.Web.Mvc.ValueProviderResult])} System.Reflection.MethodBase {System.Reflection.RuntimeMethodInfo} InnerException null

.net - Call The RenderAction In Html Helper? stackoverflow.com

im extending the htmlhelper. but it i cannot call the renderaction of it. using System.Text; using System.Web.Mvc; using System.Web.Mvc.Html; public static class ViewHelpers { public static string Text(this HtmlHelper htmlHelper, string name, object value, bool isEditMode) { htmlHelper.RenderAction(...) //cannot be called } } how can i call the RenderAction?

MVC View With Embedded Code Displays Html Out Of Sequence stackoverflow.com

I have a view in ASP.NET MVC. It takes the model object and iterates over a list of strings and displays them in a table row, like so: Details <table> <tbody> <tr> <th>Values in the database</th> </tr> <% foreach (string value in Model.lstDistinctValues) {%> <tr> <%=value%> <%} %> </tr> </tbody> The problem is that the values appear ABOVE the header. So 'Values in the database' appears at the bottom, while the values are at the top.

Dynamic Query Linq To Xml? stackoverflow.com

I want to write a query that the "where" in the query is a string something like" Dim query as string= "Name =xxxx and Date > 10 " Dim t = from book in doc.Descendants("books") Select _ [Name] = book..value, [Date] = book..value.... Where (query) I build the query string on run time

NullReference On A Value That Is Not Null stackoverflow.com

I have a function that gets a string passed to it.When testing the function, I'm getting a null reference exception on the string parameter that gets passed to it, even though the string is not null, I don't understand why I'm getting this error.I used a dummy value to verify both the string parameter in the SelectSingleNode function and the newValue string parameter being passed to my function and they both contain values, so I don't understand why it's throwing a null reference exception. Just for clarity, the purpose of the function is to write values back to the nodes of an XML file.[code]

SQL Server :: Unclosed Quotation Mark After The Character String forums.asp.net

ERROR MESSAGE: Unclosed quotation mark after the character string ') '.Incorrect syntax near 's'.I am getting this error when adding a value to a table which contains a single quotation, value is: men'sthat value is been pass as the keyword name.this is the query that i am using: Dim sql2 As String = "INSERT INTO keyword_relation_type (business_id, keyword_name, keyword_id) VALUES ('" & business_id & "','" & keywords(i) & "','" & keywordsID(i) & " ') "

Accessing Static MVC Controller Method From View stackoverflow.com

I've got an .aspx page with this in it: <%@ Import Namespace="System.Web.Mvc" %> <%= AssetController.ScriptTag("/js/Community/CommunityWizard.js")%> And I have an AssetController class: Imports System.Web.Mvc Public Class AssetController Inherits Controller Public Shared Function ScriptTag(ByVal src As String) As String Return String.Format( "<script type='text/javascript' src='/js.mvc?src={0}&{1}'></script>", System.Web.HttpContext.Current.Server.UrlEncode(src), New BuildVersion().ToString() ) End Function End Class The project has a reference added to the version of System.Web.Mvc assembly. When I try to view the page in a browser, I get a HTTP 500 with this message: BC30007: Reference required to assembly 'System.Web.Mvc, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35' containing the base class 'System.Web.Mvc.Controller'. Add one to your project. What gives? I don't understand why I can use this controller everywhere in our ASP.NET Forms/MVC hybrid application, but not in a view. EDIT: In fact, when I type <% System.Web. into the .aspx view, Mvc doesn't even appear in Intellisense!

Accessing Registry Using VB www.codeguru.com

Hi I need to access values of type String and MultiString from Registry.I tried to open a registry handle using RegOpenEx function (after decalring the required API functions in my form)as followsDim RetVal As LongDim hKey As LongRetVal = RegOpenEx(HKEY_LOCAL_MACHINE,"SoftwareMicrosoftInternet Explorer",0,KEY_ALL_ACCESS,hKey)Actually i need to get the value of Version Key in the registry which is in the section "HKEY_LOCAL_MACHINESoftwareMicrosoftInternet Explorer"But i am getting the return value as RetVal = 5 and i didnt get the handle.Please help me to identify what is wrong in the above code.Further How to Query String and multiString values from the registry.Thanks in advancewith regardsSivajothi

ADO.NET :: Error "Incorrect Syntax Near 's'" On Insert Record forums.asp.net

ERROR MESSAGE: Unclosed quotation mark after the character string ') '. Incorrect syntax near 's'. I am getting this error when adding a value to a table which contains a single quotation, value is: men's that value is been pass as the keyword name. this is the query that i am using: Dim sql2 As String = "INSERT INTO keyword_relation_type (business_id, keyword_name, keyword_id) VALUES ('" & business_id & "','" & keywords(i) & "','" & keywordsID(i) & " ') "

Error: The Project Type Is Not Supported By This Installation? forums.asp.net

I am trying to open telerik Q1 MVC examples in Visual studio 2010 and I am getting an error C:Program FilesTelerikExtensions for ASP.NET MVC Q1 2011SourceTelerik.Web.Mvc.ExamplesTelerik.Web.Mvc.Examples.csproj : error : The project file 'C:Program FilesTelerikExtensions for ASP.NET MVC Q1 2011SourceTelerik.Web.Mvc.ExamplesTelerik.Web.Mvc.Examples.csproj' cannot be opened. The project type is not supported by this installation.Do I need to change anything in my web.comfig file in order to make this run. Below I pasted my web.config file. [Code]....

Validate A Query String? stackoverflow.com

first=value first=value&arr[]=foo+bar&arr[]=baz How can I use PHP to validate a query string, which is a sequence of [name]=[value]&

What Are The Events Triggered After Clicking On A Href Link In A .Net Application stackoverflow.com

My client wants to pass values through the query string, but they don't want the query string to be displayed in the browser's address bar. The values being passed are for tracking purposes. I know that postback doesn't happen after you click on href link.Is there any way I can get the value out of the query string without displaying it in the browser's address bar? I think this may be impossible, but I may be wrong; I'm hoping to see if anyone has any answers.

Sql Server - Assign The Value I Queried To A String Which Is An Argument In A Procedure If The Argument's... stackoverflow.com

I made this procedure re-use a select query: [code..] And I use it like this if I would want the selected value placed in a textbox and it works fine [code...] However if I want the value to be passed in a string like so: [code...] The string ends up having an empty string value. How do I assign the value I queried to that String?

Postgresql/php Insert Problem www.webmasterworld.com

I,m using postgresql and keep getting this error during an insert query. query failed: ERROR: pg_atoi: zero-length string in. this is because the variable contains no value nothing so I'm trying to assign a null value if the variable is empty. if (empty($Memory)) { $Memory=NULL;} apparently postgresql will accept a null value but not nothing. However it is not accepting null either as I get the same error before and after assigning null to the variable.

How To Hide The Querystring Value From The Url forums.asp.net

i want to know how to hide the values in query string in ASP.net. here i want to send the values from one page to another page through query string with out explicitly visible the values in the query string. i want the solution with the response.redirect method. example : [URL] but i wan the link is [URL] only. I dont want use Session, or cache.

MVC :: Passing Viewdata Value To Server Side Textbox Control forums.asp.net

I am new to MVC, i tried to pass the viewdata value from Index action of homecontroller to the textbox i have on Index.aspx. I am getting the view with the label and the textbox but i am not able to get the value that passed on from the controller The below is the .aspx file <%@ Page Language="C#" MasterPageFile="~/Views/Shared/Site.Master" Inherits="System.Web.Mvc.ViewPage" %>

Just Cant Figure Out www.vbcity.com

i'm trying to insert this string Str into the database .I'm using a MSFlexGrid for the user to enter data .In this Citytable -has two fields:Cityid CityProblem :Only the Cityid gets stored in the string .For some reason the City name does not get stored .So it says the "the numbers of query values and destination values are not same "code:-------------------------------------------------------------------------------- With MSFlexGrid1 For iRows = 0 To .Rows - 1  For iCols = 0 To .Cols - 1   SQLstring = SQLstring & MSFlexGrid1.TextMatrix(iRows, iCols)   MsgBox SQLstring  Next  Str = "INSERT INTO CITYTABLE(CITY_ID,CITY) VALUES ('" & SQLstring & "')"   Conn.Execute Str  Next End With rs.CloseEnd Sub--------------------------------------------------------------------------------Any idea ?I think its got to do with Grid ..but dunno how to solve this__________________

Just Cant Figure Out! www.codeguru.com

i'm trying to insert this string Str into the database .I'm using a MSFlexGrid for the user to enter data .In this Citytable -has two fields: Cityid CityProblem :Only the Cityid gets stored in the string .For some reason the City name does not get stored .So it says the "the numbers of query values and destination values are not same "Code: With MSFlexGrid1 For iRows = 0 To .Rows - 1 For iCols = 0 To .Cols - 1 SQLstring = SQLstring & MSFlexGrid1.TextMatrix(iRows, iCols) MsgBox SQLstring Next Str = "INSERT INTO CITYTABLE(CITY_ID,CITY) VALUES ('" & SQLstring & "')" Conn.Execute Str Next End With rs.CloseEnd Sub Any idea ?I think its got to do with Grid ..but dunno how to solve this

Get Mode From A Data Grid View? www.daniweb.com

I have a data grid view populated by a query, how would I go about getting the mode from a column of values in the data grid view (from the queried data)

DataSource Controls :: Update Query To Edit Records And Save To Database? forums.asp.net

I am doing update query to edit my records and save to my database...I am getting the query expression exception...syntax error (missing operator) in query expression 'WebLogin=krish'. string strUserName = Request.QueryString["UserName"].ToString(); DateTime dateTimeNow = DateTime.Now; string ConnString = ConfigurationManager.ConnectionStrings["Data"].ConnectionString;[code].... I am getting the exception syntax error (missing operator) in query expression 'WebLogin=krish'.

FQL MultiQuery - How To Send Result List To Browser In JSON stackoverflow.com

I am using the Facebook Toolkit and making a request using FQL.Multiquery. I am using the following code which returns the correct data: Dim query1 As String = String.Format("SELECT post_id, actor_id, target_id, message FROM stream WHERE source_id in (SELECT target_id FROM connection WHERE source_id={0}) AND is_hidden = 0", FBuserId) Dim query2 As String = "SELECT pic FROM user WHERE uid IN (SELECT actor_id FROM #firstQuery)" Dim queries = New Dictionary(Of String, String) queries.Add("firstQuery", query1) queries.Add("secondQuery", query2) Dim result As List(Of Facebook.Schema.fql_result) = q.Multiquery(queries) When I run this 'result' list is populated with the results of the two queries in XML but I am unsure how I can send this list to the browser in JSON. I am using asp.net MVC.

MVC :: Html.ActionLink / Create Query String Parameters In The Link? forums.asp.net

I am using MVC to access custom reports which may be drill down reports. I use the convention of Controller/Action "Reports/Open/id/level" Ok so we hit the top level report "including my query string parameters which could be different for each report Example /Reports/Open/1?CostCentreId=10000&year=2010 I want to open up my drill down, I am binding the data to display using a class , so far so good. My sub report gets the query string parameters because I stored them in ViewData. In order to get back to the Top level report I have to create query string parameters in the link. How do I do this with an action link?

MVC :: Post Method In MVC - Public ActionResult MyPost Obj.labels Is Null Whereas Name And Description... forums.asp.net

I am using ASP.net MVC for the developement. My Model class looks like class MyModel { string name; string desc; string[] labels; } When I bind this model to the view, all the values are displayed on the view successfully. But on Postback method public ActionResult MyPost(MyModel obj) obj.labels is null whereas name and desc contains updated values. why is it so?

Invalid Cast Setting Selected Date Of Calendar Control? forums.asp.net

I am trying to set a calendar control to the value of a date returned from a query string. calExceptionDate.SelectedDate = (System. DateTime) dr["EDate"]; EDate's origin is convert(nvarchar(50), ExceptionDate,110) as EDate in a query. I am getting "Invalid Cast". I take out the (System.DateTime) and I am getting "Cannot implicitly convert type 'object' to System.DateTime'. An explicit conversion exists (are you missing a cast?)"

MVC :: Compiler Error Message: CS0308? forums.asp.net

meaning of this error? Compiler Error Message: CS0308: The non-generic method 'System.Web.Mvc.Html.LinkExtensions.ActionLink(System.Web.Mvc.HtmlHelper, string, string, string, string, string, string, System.Web.Routing.RouteValueDictionary, [Code]...

Getting Query String Value From A Variable forums.devshed.com

I have a url which is stored in a variable. I know which query string I want to extract from that url. How do I go about getting the value of the query string. PHP Code:

MVC :: Custom Action Result? forums.asp.net

I am trying to follow this example: http://blog.maartenballiauw.be/post/2008/05/ASPNET-MVC-custom-ActionResult.aspxI am getting the error: "'System.Web.Mvc.HtmlHelper' does not contain a definition for 'BuildUrlFromExpression' ..."On line: string url = helper.BuildUrlFromExpression<T>(action);

Invalid Field Comparison Error In SQl Query www.vbcity.com

Hello I am using EVB 3.0 with pocket PC 2002I am getting an error message in this SQl query:Dim paramVal1 as singleparamVal1 = CSng(val1.Text)sql1 = "Select metal from Table1 where v1=" & paramVal1 & " "the error message says invalid field comparison. My database is pocket Access and the query gives me no error if i compare a string value. But when i use a numeric value for comparison then it gives me this error. The v1 column is of number type.Please help..MahrineEdited by - mahrine_r on 11/3/2003 11:54:21 PM

MVC :: Display Html.Actionlink Through Controller? forums.asp.net

I am trying to display Html.Actionlink through controller(MVC). Here is the example what am trying to do... public string test(){ string testString = "<%: html.ActionLink('click', 'test', new AjaxOptions() { UpdateTargetId = 'test' }) %>"; return testString; } i want to display testString in view. but am not getting the actionlink in view..i can display anchors which is given below:- public string test(){ string testString = "<a href ="test"> click here</a>"; return testString; }

Japanese Character Encoding/decoding Problem phpbuilder.com

i put this as a query string in a url: & #12510;& #12452; which displays japanese text &#12510;&#12452;. In the address bar, the query string was transformed to %E3%83%9E%E3%82%A4 I was able to grab hold of this value thru the $_GET variable, but how can I resolve that value to its original form w/ is & #12510;& #12452; NOTE: i put a space in between the query string coz i'm having some trouble in formatting.

Get Value Of Query String forums.devshed.com

I am trying to get the value of a query string. The query string variable name is stored in a array value(because I need to read one particular query string) PHP Code:

MVC :: How To Display Edit And Delete View In J Query Light Box forums.asp.net

How to display edit and Delete View in J Query Light box in MVC 3.0 razor view engine?

Set A Variable Value Only If It's Not In The Query String? stackoverflow.com

I know how to get the value from the query string if the parameter exists: $hop = $_GET['hop']; But I also need to set a default value IF it's not in the query string. I tried this and it didn't work: $hop = $_GET['hop']; if ($hop = " ") { $hop = 'hardvalue'; }; handle the case where the query string has and does not have the "hop" parameter, and if it's present but not defined: example.com/?hop=xyz & example.com/ & example.com/?hop=

ADO.NET :: Unable To Fetch Just One Integer Value Using This LINQ-query forums.asp.net

I'm unable to fetch just one integer value using this LINQ-query. LINQ seems to return everything as IEnumerable but I don't want that. First query should return just one string value which is then used in another query. That one should return integer which is also return value for method: public static long GetTableIdByTableName(string name) { var result = (from aTable in objScope.Extent<Table>() where aTable.Name == name select { aTable.Id }); return ??????????? }

Page Gets Loaded When Change Any One Of The Query String Value www.sitepoint.com

I have developen one web application in php where in i have to pass many values like user id, order id, session id etc in query string for proper functioning. The site is working perfectly. The problem is that when i change any one of the query string value, the respectie page gets loaded. logically speaking this will happen if we change the query string value. But i want to know how to avoid this. For example: My website has URL similar to [URL] If i change the value of Id to 2, the respective contnt will get loaded.

How To Bind Entity Data Source To Results Of Query stackoverflow.com

I have a query that will go away an and find data Dim HSNs As String = String.Join(",", ListOfHSNs.Cast(Of String)().ToArray()) Dim query As String = "SELECT VALUE O FROM v_BillData AS O WHERE O.HSNumber IN {'" & HSNs & "'}" Dim hs As New ObjectQuery(Of v_BillData)(query, CType(Session("ObjectCon"), ObjectContext)) What I now wish to do is to use the results of this query to databind to a EntityDataSource?

MVC :: Controller.UpdateModel Breaking Change On Empty Strings? forums.asp.net

I have just upgraded a project from MVC 1 to 2 and I have come across an issue with fields updated via UpdateModel which contain an emtpy string. In MVC 1 the associated property would be set to String.Emtpy or "", but in MVC 2 it's set to null. This is causing me all kinds of problems

How To Send Dropdown Selected Value To Mvc Controller stackoverflow.com

How can i use dropdown selected value to asp.net mvc controller for filling another dropdown

DataSource Controls :: Only Numeric Value Getting From Excel forums.asp.net

everyting working fine but with this below query only numeric value getting from excel and saving into sql database String value not getting from excel? INSERT INTO dbo.ImportTest SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source=C:ook1.xls;Extended Properties=Excel 8.0')...[Sheet1$]

ADO.NET :: How To Subtract And Update Values In Item_quan Field In C_item Table forums.asp.net

am getting the value of quan and quantity like below i have given... so i want to subtract these two and update it in item_quan field in c_item table. but quan and quantity getting from query giving correct value but its not getting updated in the query below given the bolded update query below... da7 = new SqlDataAdapter("SELECT item_name, item_quan,item_cat FROM c_item WHERE (item_name = '" + fname + "') AND (item_cat = '1')", con);

Web Forms :: Displaying A Sql Count On A Datalist? forums.asp.net

i added an independent sql count statement in the code behind and want to display the results of the count in a datalist. the query needs a the parameter value of "courseID" to work except i am having difficulty getting the value to string. the error i'm getting is "Object reference not set to an instance of an object." referencing: int index = Convert.ToInt32((sender as DataListItem).ToString()); here is the statement under DataList Load [Code]....

Conversion Failed When Converting Date And/or Time From Character String? www.dreamincode.net

cmd.CommandText = "INSERT INTO Dropping (form_num, filing_date, approval_date, status) VALUES ('" + fnum + "', '" + deyt + "', '" + nulll + "', '" + stat + "')" here is an sql query statement i run in vb.net. i keep getting the error of "Conversion failed when converting date and/or time from character string." whenever i try to execute this. the datatype of filing_date and approvale_date is "text" but the deyt variable is originally Date, converted to string: (Date.Today).ToString, like so. nulll is simply a variable with vbNullChar as its value.

T SQL Subquery Returning Multiple Results? www.phpbuilder.com

In a sub-query that returns multiple results, is there a way to take those results and return them as a list so the query doesn't fail?The error I'm getting is:SQL Server Database Error: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.This sub-query is within the SELECT portion of the statement and I want to have all of the results returned show as one string

C# - LoadLibrary Call From MVC Application Running In IIS? stackoverflow.com

I'm having trouble executing this line of code in my MVC application: IntPtr hModule = LoadLibrary(BondProbeSettings.AssemblyFilePath); The problem is that hModule is always 0. If I run the same code with the same value for BondProbeSettings.AssemblyFilePath but from a console application instead of the MVC app hModule is non-zero. Are there any security issues I need to consider? The signature for LoadLibrary is: [DllImport("kernel32.dll", CharSet = CharSet.Auto)] static extern IntPtr LoadLibrary(string lpFileName);

Get Values From Query String Using Janrain's OpenID Library stackoverflow.com

I am using Janrains PHP openID library. All is working perfectly except when I try and pull values from the query string on the script that is returned to after the user is authorized. Here is the first part of the query string: [URL]...I am able to get the value of the 'janrain_nonce' item on the query string, but am not able to get any values for things like 'openid.op_endpoint'. For example, this $test = $_GET["janrain_nonce"]; returns a value ok into $test, but the the value of $test is blank using the following. $test = $_GET["openid.claimed_id"]; What I am trying to do is get one of the values from the query string to see if it contains 'google' or not, as I have some processing specific to Google to do.

MVC :: Entity / Getting An Error Indicating That There Is No Key For A Table? forums.asp.net

I am working through the MVC Music Store example that is listed on this site. I am also trying to create my own MVC application in which I have several tables defined in a very similar way to the music store. When I am defining my Models and running the application I am getting an error indicating that there is no key for a table that I know has a key. For example Table1 int Id string fld1 int Table2_id Table2 int Id string fldxyz Code: public class Table1 { public int Id; public string fld1; public int Table2_id; public Table2 table2; } public class Table2 { public int Id; public string Fldxyz } of course the Id fields on the database are setup as being the key fields and are unique. When I run the application I am getting an error indicating the Table2 doesn't have a key and that it needs to be defined.

Query Pulling From Form www.access-programmers.co.uk

I am having an issue pulling information from a form into a query. In my criteria column in the query i have: [Forms]![frm_createcsv]![txtCriteria] it pulls from a valid string from a textbox txtCriteria. My vba code is: Dim query as string query = "pkg_not_registered_email" filename = "C:querytester" & Format(Date, "YYYY_MMDD") & "_" & cboCountry.Value & "_" & ".csv" DoCmd.TransferText acExportDelim, "", query, filename DoCmd.Open query ____________________ This exact code worked previously with another function and a different query so I do not understand why it is not working now! Help! :(

Re: Catastropic Failure www.vbcity.com

I'm getting an odd error when executing the below code. I can't seem to access the rsetSearchFPCO recordset after I execute an INSERT statement. I get the error Catastropic Failure.Any ideas anyone?Code:Dim DB As New ADODB.ConnectionDim rsetSearchFPCO As ADODB.RecordsetDB.Open "Driver={SQL Server};Server=;Database=mydb"'Initialise rsetSearchSet rsetSearchFPCO = New ADODB.Recordset    'Execute SQL passed from buildCOqueryrsetSearchFPCO.Open BuildCOQuery(False), DB, adOpenStaticIf Not rsetSearchFPCO.EOF And Not rsetSearchFPCO.BOF Then   Do Until rsetSearchFPCO.EOF            Query = ""            Query = Query & "INSERT INTO"            Query = Query & " dbo.customerorderhistory"            Query = Query & " ("            Query = Query & " branchno,"            Query = Query & " customerorderno,"            Query = Query & " datefullypaid"            Query = Query & " )"            Query = Query & " VALUES"            Query = Query & " ("            Query = Query & " " & rsetSearchFPCO.Fields("branchno").Value & ","            Query = Query & " " & rsetSearchFPCO.Fields("customerorderno").Value & ","            Query = Query & " '" & Format(rsetSearchFPCO.Fields("datefullypaid").Value, "yyyy-mm-dd") & "'"            Query = Query & " )"                        DB.BeginTrans            DB.Execute Query            DB.CommitTrans            MsgBox rsetSearchFPCO.Fields("customerorderno").Value '-This will give an error <Catastropic Failure>            rsetSearchFPCO.MoveNext   LoopEnd IfEdited by - nige on 11/4/2005 6:42:34 AM

Session Object Not Work With Combined Mvc And Webform Application? forums.asp.net

Environment used - Asp.net mvc 1.0 with c# Problem -I have used simple mvc application. and also added webform into mvc application.and it is working fine. but when i used session object for sharing data between mvc and webapplication. it is not working. I have put Session["logon"] = "logon"; object into mvc controller and when i access this into webform then there is no value in session object.

C# - Retrieve The Name Of The Attribute Dynamically Without Specifying The Name Of The Attribute? stackoverflow.com

I am developing asp.net mobile application. I am using LINQ to XML to query XML file. I am using the following query to retrieve the name & value of the query dynamically as follows var TotalManifolds = from MF in FieldRoot.Element("FIELD-DEFINITION").Element("MANIFOLDS").Elements("MANIFOLD") join SLT in FieldRoot.Element("FIELD-DEFINITION").Element("SLOTS").Elements("SLOT") on (string)MF.Attribute("MID") equals (string)SLT.Attribute("PARENT") select new { SlotName = (string)SLT.Attribute("NAME").Value, SlotValue = (string)SLT.Attribute("NAME").Value }; In the following statement of above query I want to retrive the name of the attribure dynamically without explicitly specifying the name of the attribute SlotName = (string)SLT.Attribute("NAME").Value Here I am explicitly specifying the name. I want to code which can dynamically retrieve the name of the attribute. I am new to Linq to xml. how this can be done programatically? or can you provide me the link through which I can resolve the above issue ?

MVC :: Add Html Attribute To Validationsummary? forums.asp.net

I'm trying to add a new html attribute to my ValidationSummary Html control like this: <%= Html.ValidationSummary(new { id = "validationSummary" })%> VS compiler has no problem with it, however when it comes to running it in the browser I get the nasty error message saying: 'System.Web.Mvc.HtmlHelper<Adgistics.Mvc.ViewModels.Forum.IForumCreateOutModel>' does not contain a definition for 'ValidationSummary' and the best extension method overload 'System.Web.Mvc.Html.ValidationExtensions.ValidationSummary(System.Web.Mvc.HtmlHelper, string)' has some invalid arguments

MVC :: Change Default Value Type Conversion Error Message? forums.asp.net

How can I change default value type conversion error message while posting form value in mvc 2.

How To Check Dat Value In Numeric Or String forums.asp.net

getting a column value 4rm data table. i wana dertermine dat value is string or numeric.

Access :: Getting The Value From Database Split By 3? forums.asp.net

I have a problem regarding on getting the value of the string. For example I have '345' on my string and on my database I have field of tables that the strings are divisible by 3 like for example 934526345789 and it was stored on my msaccess'97 database. My problem is that I am comparing the strings i have, if it is existing or not but my problem is that on the database field it should be chunk 3 by 3. Like the example I have, it is 934,526,345,789 so only 1 number of 345 is there. But if you observed there is another 345 there but chunk therefore it is not the strings same as what i have on my strings. So if in the database there is 934526, the string that i have that was '345' is not existing to that value because it is 934,526. Below is my query where i used but seems like it is incorrect. [Code].... The query or the syntax on how to get that.

MVC :: Create And Set Value Of Session In Controller? forums.asp.net

how I can create and set value of session in controller and get value this session because I can't find good tutorial about that in asp.net mvc :/

Chech Whether A Textbox Value Is Numeric Or String stackoverflow.com

Is there a (built-in) way in JavaScript to check if a string is a valid number? i want to check whether a textbox contains a numeric value or a string using javascript but when i enter a number 1234 in textbox still getting query is a string.

Asp.net - Escaping Apostrophes With Parameter Query Not Working? stackoverflow.com

I am trying to prevent from having to escape apostrophes in my string variables by using a parameterized query with a OleDbConnection, but it is not working. I am trying to insert into an Access db and I keep getting those pesky html codes. Dim pConn As New OleDb.OleDbConnection pConn = New OleDbConnection(cb.ConnectionString) Dim SqlString As String = "INSERT INTO Strings (Mlt_String_ID, Lng_ID, Strg_Name, Sht_Text, Lng_Text, Alt_Text) Values (@Mlt_String_ID,@Lng_ID,@Strg_Name,@Sht_Text,@Lng_Text,@Alt_Text)" [code]....

MVC 2 - Add A Default Property To A Strongly Typed Html.Textbox Helper stackoverflow.com

The strongly typed helpers are now written like this - <%= Html.TextBoxFor(model => model.State) %> I need to add a default value to a textbox. In the prior version of Asp.Net MVC it was easy to assign a default value. I thought doing the following would work in MVC 2- <%= Html.TextBoxFor(model => model.CountyId, new{ value = 840 })%> This, however, does not work for me in Asp.Net MVC 2. The value is still blank for the textbox. I want to make sure that this isn't some random error that I am having. Has anyone else encountered the same problem? I have searched and searched to find more information on the default property for the html helpers in MVC 2, but I can't find anything. Does anyone out there know how to correctly assign a default value to a textbox in Asp.Net MVC 2?

Pass Value From Javascript To File? stackoverflow.com

im getting value via JQuery as something like this var query= popURL.split('?'); var dim= query[1].split('&'); var popWidth = dim[0].split('=')[1]; //Gets the first query string value var id = dim[1].split('=')[1]; Now i want to send or get this "id" value into same php file. i think we can only get value on other php page using get method. i want to get value on same php file.I think we can do with this using AJAX right

Web Forms :: How To Get Somewhat Complex Parameters From A Querystring In Code Behind forums.asp.net

i have a query string as follows http://localhost/SampleAppl/Pages/SampleTest.aspx?State="SUBMIT"&Fields="{{label='Acc Nbr 1:',Id='1001',mask='F'},{ label='Acc Nbr 2:',Id='1002', Value='Second Account', mask='F'},{ label='Acc Nbr 3:',Id='1003', Value='Third Account', mask='F'}}" i want to get the parameters in my page load event (language as C#). i dont know how the get the values for "Label", "ID", "Value" and "Mask" from the query string. all the data need to be put on the array like LabelArr, IDArr, ValueArr and MaskArr.

Web Forms :: How To Session Value Be Changed While Debugging A Web Form / Similar To The Way A Query... forums.asp.net

I have a web form the redirects to a second web form. The second web form uses a values stored in the Query String. And for debugging I can conveniently change the query string values in the URL. Is their a way to change the value of a session value while debugging. Meaning can this be done without having to write any type of C# or Scripting code? It would be nice if I could do it by changing the URL like what is done with the query string. Example of using query string. [URL] this be done with session value??. I need to do this for debugging purposes.

Jquery :: .net - Update Href Of Link Button stackoverflow.com

I am using a link button to redirect the page to my desired location with some query string value from Jquery. The Link Button code are as follows: [Code]... What i wanted to do is it will collect all the comma separated value from check boxes and pass it to the another page with that collected value as query string. On click of that Link Button it should carry all the comma separated values and redirected to the desired page.

Index Was Outside The Bounds Of The Array? www.vbforums.com

I'm getting this annoying error box popping up on the last line of the coding below. - The first line gets the user input, which are values seperated by comma's.. there are allways 7 value in the input - The second line splits the values at the commas - The third line is for testing, it basicly says that the 7th string is that value But this third line is giving the error, how come?? PHP Dim gatherstring As String = textbox1.text Dim arraygather As String = gatherstring.Split(",") arraygather(7) = "fcKCNBQ3SmnaNrywFfZEdNjKm56H9IcXJU9h+WI"

Access Database Speed www.codeguru.com

I have an Access 2000 database which can grow to about 500MB.I have normalized the database to make it more efficient.However it still takes a couple of minutes to complete the Query and the database is only 50MB right now.What am I doing wrong? Is there a more efficient way to open and query the database?Should I use MS SQL Server instead?Below is my code for querying the database and some examples of my SQL strings.My queries work fine they just take forever once the database starts getting big.Thanks for any help.Sub GetODBCValue(strQuery as string, txtMenuValue as TextBox, strFormat as string) Dim conStatistics as ADODB.Connection Dim rstValue as ADODB.Recordset on error GoTo ErrHandler '//Open The Connection set conStatistics = new ADODB.Connection set rstValue = new ADODB.Recordset '//Query Database conStatistics.Open "DSN=ODBCErrorLog;uid=sa;pwd=;" rstValue.Open strQuery, conStatistics, adOpenStatic, adLockReadOnly '//Update Field on Menu Page If Not IsNull(rstValue.Fields(0)) then txtMenuValue = Format(rstValue.Fields(0), strFormat) else txtMenuValue = Format(0, strFormat) End If '//Close Recordset And Connection rstValue.Close conStatistics.Close '//set to nothing to Prevent Memory Leaks set rstValue = nothing set conStatistics = nothing Exit SubErrHandler: ProccessError ("GetODBCValue")End SubSQL Strings:strQuery = "SELECT Sum([DownTime].[Duration]) " & _ "as [Duration] FROM DownTime " & _ "WHERE([DownTime].[Scheduled] = 2)" & _ "AND ([DownTime].[Start time]) &gt; (#" & _ DateValue(txtShftDate.Text) & " " & TimeValue(txtShftTime.Text) & "#)" '//get Value from Db GetODBCValue strQuery, txtShftBypass, "0.00"'//Define Query string strQuery = "SELECT Sum([CycleTime].[Cycle time])/60 " & _ "as [Production time]FROM CycleTime " & _ "WHERE (([CycleTime].[Cycle time] &gt; 0) " & _ "AND ([CycleTime].[Start time]) &gt; (#" & _ DateValue(txtShftDate.Text) & " " & TimeValue(txtShftTime.Text) & "#))" '//get Value from Db GetODBCValue strQuery, txtShftProdTime, "0.00"'//Define Query string strQuery = "SELECT Sum([DownTime]![Duration]) " & _ "as [Scheduled Downtime] From DownTime " & _ "WHERE ((([DownTime]![Scheduled])=0) " & _ "AND ([DownTime].[Start time]) &gt; (#" & _ DateValue(txtShftDate.Text) & " " & TimeValue(txtShftTime.Text) & "#))" '//get Value from Db GetODBCValue strQuery, txtShftScedTime, "0.00"'//Define Query string strQuery = "SELECT 24*60*(Max([ErrorLog].[time Occured])" & _ "-Min([ErrorLog].[time Occured]))/(Count([ErrorLog].[time Occured])-1)" & _ "as MTBA From ErrorLog " & _ "WHERE ((ErrorLog.[Task Index]&gt;0) and (ErrorLog.[Total time]&gt;0) " & _ "AND (ErrorLog.[error Code] &gt; -13000) " & _ "AND (([ErrorLog].[time Occured]) &gt; (#" & _ DateValue(txtShftDate.Text) & " " & TimeValue(txtShftTime.Text) & "#)))" '//get Value from Db GetODBCValue strQuery, txtShftMTBA, "0.00"

HttpHandlers / Modules :: How Secure Passing User Credentials Like User Name, Password Values In Query... forums.asp.net

How secure passing user credentials like user name, password values in query string to httphandlerlike login.ashx?uid=xxx&pwd=yyy

How To See A Query String In FireFox www.vbforums.com

In IE 7, I can right click on my page and select properties and (usually) see the query string that was passed to that page. How do I see this in FireFox? I am having a bug where I should be passing consecutive numbers in the query string, such as deal_ik=1,2,3,4,5 etc but 5 is missing. So I want to examine the query string that is actually getting passed.

Ldap Query Returns Null Result When Deployed? stackoverflow.com

I'm using a very simple Ldap query in my asp.net mvc 2.0 site: String ldapPath = ConfigReader.LdapPath; String emailAddress = null; try { [code].... I'm running it under the default app pool.

ADO.NET :: Error When Try To Delete A Master Record After Changed The Name Of A Foreign Key forums.asp.net

I have two tables one named article and the other article_type, where the articles table have a foreign key column that references the article_type primary table named "article_status". so i change the name of the article_status foreign key to be article_status_id, but now each time i tried to delete an article type column it raised an error said the the article_status column cannot be found , although i did not mentioned that column in my code here is the full error :- System.Data.SqlClient.SqlException was unhandled by user code Message=Invalid column name 'Article_status'. Source=.Net SqlClient Data Provider ErrorCode=-2146232060 LineNumber=1 Number=207 Procedure="" Server=\.pipeE97065CB-CF67-4B sqlquery State=1 StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult) at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries) at System.Data.Linq.SqlClient.SqlProvider.CompiledQuery.Execute(IProvider provider, Object[] arguments) at System.Data.Linq.CommonDataServices.DeferredSourceFactory`1.ExecuteKeyQuery(Object[] keyValues) at System.Data.Linq.CommonDataServices.DeferredSourceFactory`1.Execute(Object instance) at System.Data.Linq.CommonDataServices.DeferredSourceFactory`1.DeferredSource.GetEnumerator() at System.Data.Linq.EntitySet`1.Load() at System.Data.Linq.EntitySet`1.get_Count() at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at System.Data.Linq.Table`1.DeleteAllOnSubmit[TSubEntity](IEnumerable`1 entities) at ProfessionalNetworkWebApplication.Models.ProfessionalNetworkRepository.Delete(Article_Type article) in C:UsersUserdocumentsvisual studio 2010ProjectsProfessionalNetworkWebApplicationProfessionalNetworkWebApplicationModelsProfessionalNetworkRepository.cs:line 35 at ProfessionalNetworkWebApplication.Controllers.ArticleTypeController.Delete(Int32 id, String confirmButton) in C:UsersUserdocumentsvisual studio 2010ProjectsProfessionalNetworkWebApplicationProfessionalNetworkWebApplicationControllersArticleTypeController.cs:line 73 at lambda_method(Closure , ControllerBase , Object[] ) at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters) at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClassd.<InvokeActionMethodWithFilters>b__a() at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) InnerException:

MVC :: Parser Error Message: Could Not Load Type "System.Web.Mvc.ViewMasterPage" forums.asp.net

I'm only pretty new to .net MVC. I have a solution which has 2 projects one is asp .net 2.0 and the other is asp .net MVC. I created the MVC project and it was working fine. I then imported the project into the solution in it's own folder and now I'm getting an error when I try to run it. What am I missing? Parser Error Message: Could not load type 'System.Web.Mvc.ViewMasterPage'.

SQL Query Incorrect Syntax Help forums.asp.net

I am getting a SQLExcepetion error near , in this query string...so obvicously my query string is wrong... could someone help me get this query string right please...   Thanks "Select OrgID, OrgName From aspnet_OrgNames Where UserID = @UserID, OrgID = @OrgID"

Add The Variable To The Query String forums.devshed.com

having trouble getting a query string/URL to append a couple of variables from a function (well, trying to get ONE working). Basically, once a user makes a selection from a form, I want the script to add the variable to the query string, which is then sent off to a PHP script. If I manually enter the 'social_housing_type' as a number in the query string, it executes properly, I just can't get it to do it from the form. [Code]...

Significant Advantages Of MVC? stackoverflow.com

I'm slowly getting into MVC, but it's still relatively new to me. From what I've discovered by doing a few tutorials, MVC provides an interface for communication between the database and the website and in general allows for better organization of the code. Are there other significant advantages to using an MVC structure? What would be an example of a time when you wouldn't want to user MVC, even if you are communicating with a database?

How To Get The Values Of A Query Into An Array Or String www.xtremevbtalk.com

Hi all,Can somebody tell me how to get the results of a query into an array or a string ?The query I'm talking about is a predifined Access2000 query and it will return the values of two fields of a table. is there a way to get this both string values into the VBA part of Access ?ThanksMike