With <% Server.Execute "/dev/1/utility.asp" %> I get a 'type mistmatch error on my connection string 'GetConnection'. Why would this be so if server.execute is including the same file as the include file in the same directory...? Thanks Jason [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => [ip] => jason@catamaran [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 1 [islastshown] => [isfirstshown] => 1 [attachments] => [allattachments] => ) -->[quote] > > With > > <% Server.Execute "/dev/1/utility.asp" %>[/quote] You realize those are not necessarily the same path, right? Why did you add /dev/1/ to the server.execute call? [quote] > I get a 'type mistmatch error on my connection string 'GetConnection'.[/quote] I think you're confusing the roles of #include vs. server.execute. Server.Execute goes out and runs a script file. Any variables created there are not kept in memory and the resuming portion of the calling script is not going to be aware of them. My suggestion: stick to #includes, you're using those for the right reasons. I don't think you're sure why you even changed it from #include to Server.Execute. -- [url]http://www.aspfaq.com/[/url] (Reverse address to reply.) [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => Aaron [SQL Server MVP] [ip] => ten.xoc@dnartre [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 2 [islastshown] => [isfirstshown] => [attachments] => [allattachments] => ) --> > >With > ><% Server.Execute "/dev/1/utility.asp" %> > >I get a 'type mistmatch error on my connection string 'GetConnection'. > >Why would this be so if server.execute is including the same file as the >include file in the same directory...?[/quote] The simple explanation is that something in your utility.asp needed something in the asp file that included it. By doing an execute you don't have that soemthing. Now as to what that something might be, we couldn't tell without some code, which you didn't provide. Jeff [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => <411abddc.106993528@msnews.microsoft.com> [ref] => [htmlstate] => on_nl2br [postusername] => Jeff Cochran [ip] => jeff.nospam@zin [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 3 [islastshown] => [isfirstshown] => [attachments] => [allattachments] => ) --> > > > > With > > > > <% Server.Execute "/dev/1/utility.asp" %>[/quote] > > You realize those are not necessarily the same path, right? Why did you[/quote] add[quote] > /dev/1/ to the server.execute call? >[quote] > > I get a 'type mistmatch error on my connection string 'GetConnection'.[/quote] > > I think you're confusing the roles of #include vs. server.execute. > Server.Execute goes out and runs a script file. Any variables created[/quote] there[quote] > are not kept in memory and the resuming portion of the calling script is[/quote] not[quote] > going to be aware of them. > > My suggestion: stick to #includes, you're using those for the right[/quote] reasons.[quote] > I don't think you're sure why you even changed it from #include to > Server.Execute. > > -- > [url]http://www.aspfaq.com/[/url] > (Reverse address to reply.) > >[/quote] [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => [ip] => jason@catamaran [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 4 [islastshown] => 1 [isfirstshown] => [attachments] => [allattachments] => ) --> Type mismatch when using Server.Execute? - ASP Database

Type mismatch when using Server.Execute? - ASP Database

Whe I replace: <!--#include file="utility.asp"--> With <% Server.Execute "/dev/1/utility.asp" %> I get a 'type mistmatch error on my connection string 'GetConnection'. Why would this be so if server.execute is including the same file as the include file in the same directory...? Thanks Jason...

  1. #1

    Default Type mismatch when using Server.Execute?

    Whe I replace: <!--#include file="utility.asp"-->

    With

    <% Server.Execute "/dev/1/utility.asp" %>

    I get a 'type mistmatch error on my connection string 'GetConnection'.

    Why would this be so if server.execute is including the same file as the
    include file in the same directory...?

    Thanks
    Jason


    Guest

  2. #2

    Default Re: Type mismatch when using Server.Execute?

    > Whe I replace: <!--#include file="utility.asp"-->
    >
    > With
    >
    > <% Server.Execute "/dev/1/utility.asp" %>
    You realize those are not necessarily the same path, right? Why did you add
    /dev/1/ to the server.execute call?
    > I get a 'type mistmatch error on my connection string 'GetConnection'.
    I think you're confusing the roles of #include vs. server.execute.
    Server.Execute goes out and runs a script file. Any variables created there
    are not kept in memory and the resuming portion of the calling script is not
    going to be aware of them.

    My suggestion: stick to #includes, you're using those for the right reasons.
    I don't think you're sure why you even changed it from #include to
    Server.Execute.

    --
    [url]http://www.aspfaq.com/[/url]
    (Reverse address to reply.)


    Aaron [SQL Server MVP] Guest

  3. #3

    Default Re: Type mismatch when using Server.Execute?

    On Mon, 9 Aug 2004 12:20:21 -0400, <jasoncatamaranco.com> wrote:
    >Whe I replace: <!--#include file="utility.asp"-->
    >
    >With
    >
    ><% Server.Execute "/dev/1/utility.asp" %>
    >
    >I get a 'type mistmatch error on my connection string 'GetConnection'.
    >
    >Why would this be so if server.execute is including the same file as the
    >include file in the same directory...?
    The simple explanation is that something in your utility.asp needed
    something in the asp file that included it. By doing an execute you
    don't have that soemthing.

    Now as to what that something might be, we couldn't tell without some
    code, which you didn't provide.

    Jeff
    Jeff Cochran Guest

  4. #4

    Default Re: Type mismatch when using Server.Execute?

    Ok, they are the same path, I was experiment with relative and virtual
    paths...

    The reason I attempted a server.execute was based on the possibility of my
    other sub-domains on the same server consuming this file..

    However, I realise a virtual include is probably the best route as it
    appears from what you told me that I cannot carry declared variables over to
    the file that consumes it, right?

    - Jason

    "Aaron [SQL Server MVP]" <ten.xocdnartreb.noraa> wrote in message
    news:eMfhusjfEHA.720TK2MSFTNGP11.phx.gbl...
    > > Whe I replace: <!--#include file="utility.asp"-->
    > >
    > > With
    > >
    > > <% Server.Execute "/dev/1/utility.asp" %>
    >
    > You realize those are not necessarily the same path, right? Why did you
    add
    > /dev/1/ to the server.execute call?
    >
    > > I get a 'type mistmatch error on my connection string 'GetConnection'.
    >
    > I think you're confusing the roles of #include vs. server.execute.
    > Server.Execute goes out and runs a script file. Any variables created
    there
    > are not kept in memory and the resuming portion of the calling script is
    not
    > going to be aware of them.
    >
    > My suggestion: stick to #includes, you're using those for the right
    reasons.
    > I don't think you're sure why you even changed it from #include to
    > Server.Execute.
    >
    > --
    > [url]http://www.aspfaq.com/[/url]
    > (Reverse address to reply.)
    >
    >

    Guest

Similar Threads

  1. Server.Transfer returning Type Mismatch: 'LBound'
    By Eddy Miller in forum Dreamweaver AppDev
    Replies: 0
    Last Post: May 12th, 12:14 AM
  2. Type mismatch?
    By xool in forum ASP
    Replies: 5
    Last Post: September 11th, 05:06 PM
  3. Type Mismatch
    By Ray in forum ASP
    Replies: 7
    Last Post: July 24th, 09:48 AM
  4. Type mismatch in expression
    By Jim in forum Microsoft Access
    Replies: 0
    Last Post: July 22nd, 08:01 AM
  5. Type Mismatch again
    By Miguel Orrego in forum ASP Database
    Replies: 3
    Last Post: July 5th, 06:26 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •